DBA Data[Home] [Help]

APPS.HZ_BES_BO_GEN_PKG dependencies on HZ_UTILITY_V2PUB

Line 67: hz_utility_v2pub.DEBUG (

63: FND_FILE.LOG = 1 - means log file
64: FND_FILE.LOG = 2 - means out file
65: */
66: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
67: hz_utility_v2pub.DEBUG (
68: p_message=>message,
69: p_prefix=>l_prefix,
70: p_msg_level=>fnd_log.level_procedure);
71: END IF ;

Line 299: hz_utility_v2pub.DEBUG (

295: l_tmp NUMBER;
296:
297: BEGIN -- gen_pkg_body
298: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
299: hz_utility_v2pub.DEBUG (
300: p_message=>'genPkgBdyHdr()+',
301: p_prefix=>l_prefix,
302: p_msg_level=>fnd_log.level_procedure);
303: END IF ;

Line 329: hz_utility_v2pub.DEBUG (

325: END IF;
326: EXCEPTION
327: WHEN NO_DATA_FOUND THEN
328: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
329: hz_utility_v2pub.DEBUG (
330: p_message=>'pkg body does not exist.',
331: p_prefix=>l_prefix,
332: p_msg_level=>fnd_log.level_procedure);
333: END IF ;

Line 336: hz_utility_v2pub.DEBUG (

332: p_msg_level=>fnd_log.level_procedure);
333: END IF ;
334: WHEN OTHERS THEN
335: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
336: hz_utility_v2pub.DEBUG (
337: p_message=>sqlerrm,
338: p_prefix=>l_prefix,
339: p_msg_level=>fnd_log.level_procedure);
340: END IF ;

Line 363: hz_utility_v2pub.debug(p_message=>'genPkgBdyHdr()-',

359: l(' *=======================================================================*/');
360: l(' ');
361:
362: if fnd_log.level_procedure>=fnd_log.g_current_runtime_level then
363: hz_utility_v2pub.debug(p_message=>'genPkgBdyHdr()-',
364: p_prefix=>l_prefix,
365: p_msg_level=>fnd_log.level_procedure);
366: end if;
367:

Line 379: hz_utility_v2pub.DEBUG (

375: l_tmp NUMBER;
376:
377: BEGIN -- gen_pkg_hdr
378: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
379: hz_utility_v2pub.DEBUG (
380: p_message=>'genPkgHdr()+',
381: p_prefix=>l_prefix,
382: p_msg_level=>fnd_log.level_procedure);
383: END IF ;

Line 404: hz_utility_v2pub.debug(p_message=>'genPkgHdr()-',

400: l(' *=======================================================================*/');
401: l(' ');
402:
403: if fnd_log.level_procedure>=fnd_log.g_current_runtime_level then
404: hz_utility_v2pub.debug(p_message=>'genPkgHdr()-',
405: p_prefix=>l_prefix,
406: p_msg_level=>fnd_log.level_procedure);
407: end if;
408:

Line 433: hz_utility_v2pub.debug(p_message=>'genPkgBdyTail()+',

429: l_debug_prefix VARCHAR2(15) := 'PKGTAIL:';
430: BEGIN
431:
432: if fnd_log.level_procedure>=fnd_log.g_current_runtime_level then
433: hz_utility_v2pub.debug(p_message=>'genPkgBdyTail()+',
434: p_prefix=>l_debug_prefix,
435: p_msg_level=>fnd_log.level_procedure);
436: end if;
437:

Line 444: hz_utility_v2pub.debug(p_message=>'genPkgBdyTail()-',

440: -- compile the package.
441: HZ_GEN_PLSQL.compile_code;
442:
443: if fnd_log.level_procedure>=fnd_log.g_current_runtime_level then
444: hz_utility_v2pub.debug(p_message=>'genPkgBdyTail()-',
445: p_prefix=>l_debug_prefix,
446: p_msg_level=>fnd_log.level_procedure);
447: end if;
448:

Line 524: l2i(' HZ_UTILITY_V2PUB.DEBUG(');

520: BEGIN
521: l(' ');
522: l2i('IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN');
523: l(' ');
524: l2i(' HZ_UTILITY_V2PUB.DEBUG(');
525: l2i(' p_message=>'''||p_msg||''',');
526: l2i(' p_prefix=>'''||p_prefix||''',');
527: l2i(' p_msg_level=>fnd_log.level_procedure);');
528: l2i('END IF;');

Line 611: hz_utility_v2pub.debug(p_message=>'GENBOSQL()+',

607:
608: BEGIN
609:
610: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
611: hz_utility_v2pub.debug(p_message=>'GENBOSQL()+',
612: p_prefix=>l_debug_prefix,
613: p_msg_level=>fnd_log.level_procedure);
614: END IF;
615: -- set the retun status to false. If the SQL generation is successfull, this

Line 620: hz_utility_v2pub.debug(

616: -- will set to TRUE
617: P_STATUS := FALSE;
618: OPEN c_bo(p_bo_code);
619: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
620: hz_utility_v2pub.debug(
621: p_message=>'cursor opened',
622: p_prefix=>l_debug_prefix,
623: p_msg_level=>fnd_log.level_procedure);
624: END IF;

Line 630: hz_utility_v2pub.debug(

626: FETCH c_bo BULK COLLECT INTO l_node_tbl;
627: CLOSE c_bo;
628:
629: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
630: hz_utility_v2pub.debug(
631: p_message=>'bulk collected and cursor closed',
632: p_prefix=>l_debug_prefix,
633: p_msg_level=>fnd_log.level_procedure);
634: END IF;

Line 637: hz_utility_v2pub.debug(

633: p_msg_level=>fnd_log.level_procedure);
634: END IF;
635: l_node_count := l_node_tbl.COUNT;
636: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
637: hz_utility_v2pub.debug(
638: p_message=>'number of nodes in the tree are:'||l_node_count,
639: p_prefix=>l_debug_prefix,
640: p_msg_level=>fnd_log.level_procedure);
641: END IF;

Line 645: hz_utility_v2pub.debug(

641: END IF;
642: FOR i IN l_node_tbl.FIRST..l_node_tbl.LAST
643: LOOP
644: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
645: hz_utility_v2pub.debug(
646: p_message=>'--node '||i||':BO:'||l_node_tbl(i).bo_code||':ent:'||l_node_tbl(i).entity_name||':parent:'||l_node_tbl(i).parent_bo_code,
647: p_prefix=>l_debug_prefix,
648: p_msg_level=>fnd_log.level_procedure);
649: END IF;

Line 727: hz_utility_v2pub.debug(

723: li(G_RT_NODE_BOCODE||''''||l_node_tbl(1).BO_CODE||'''');
724: END IF;
725: ELSE
726: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
727: hz_utility_v2pub.debug(
728: p_message=>'invalid first node a.k.a invalid root_node node ',
729: p_prefix=>l_debug_prefix,
730: p_msg_level=>fnd_log.level_procedure);
731: END IF;

Line 778: hz_utility_v2pub.debug(

774: -- first node right paranthisis. Hence, we skip part to figure out the
775: -- right paranthesis for the second node and go directly to figuring out the
776: -- SQL for second node.
777: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
778: hz_utility_v2pub.debug(
779: p_message=>'the node that is being processed is: '||i,
780: p_prefix=>l_debug_prefix,
781: p_msg_level=>fnd_log.level_procedure);
782: END IF;

Line 837: hz_utility_v2pub.debug(

833: l_rp_tbl(l_rpc).rp := l_rp;
834: l_rp_tbl(l_rpc).BO_CODE := l_node_tbl(i).PARENT_BO_CODE;
835: l_rp_tbl(l_rpc).PARENT_BO_CODE := l_node_tbl(i-1).PARENT_BO_CODE;
836: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
837: hz_utility_v2pub.debug(
838: p_message=>'The prev node is type 1 parent of the current node '||i,
839: p_prefix=>l_debug_prefix,
840: p_msg_level=>fnd_log.level_procedure);
841: hz_utility_v2pub.debug(

Line 841: hz_utility_v2pub.debug(

837: hz_utility_v2pub.debug(
838: p_message=>'The prev node is type 1 parent of the current node '||i,
839: p_prefix=>l_debug_prefix,
840: p_msg_level=>fnd_log.level_procedure);
841: hz_utility_v2pub.debug(
842: p_message=>'storing the right paranthesis. details of the hashmap',
843: p_prefix=>l_debug_prefix,
844: p_msg_level=>fnd_log.level_procedure);
845: hz_utility_v2pub.debug(

Line 845: hz_utility_v2pub.debug(

841: hz_utility_v2pub.debug(
842: p_message=>'storing the right paranthesis. details of the hashmap',
843: p_prefix=>l_debug_prefix,
844: p_msg_level=>fnd_log.level_procedure);
845: hz_utility_v2pub.debug(
846: p_message=>'rec:'||l_rpc||'BOCODE:'||l_node_tbl(i).PARENT_BO_CODE||':parent node:'||(i-1)||':PARENTBO:'||l_node_tbl(i-1).PARENT_BO_CODE,
847: p_prefix=>l_debug_prefix,
848: p_msg_level=>fnd_log.level_procedure);
849: END IF;

Line 882: hz_utility_v2pub.debug(

878: l_rp_tbl(l_rpc).rp := l_rp;
879: l_rp_tbl(l_rpc).BO_CODE := l_node_tbl(i).BO_CODE;
880: l_rp_tbl(l_rpc).PARENT_BO_CODE := l_node_tbl(i).PARENT_BO_CODE;
881: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
882: hz_utility_v2pub.debug(
883: p_message=>'The prev node is type 2 parent of the current node '||i,
884: p_prefix=>l_debug_prefix,
885: p_msg_level=>fnd_log.level_procedure);
886: hz_utility_v2pub.debug(

Line 886: hz_utility_v2pub.debug(

882: hz_utility_v2pub.debug(
883: p_message=>'The prev node is type 2 parent of the current node '||i,
884: p_prefix=>l_debug_prefix,
885: p_msg_level=>fnd_log.level_procedure);
886: hz_utility_v2pub.debug(
887: p_message=>'storing the right paranthesis. details of the hashmap',
888: p_prefix=>l_debug_prefix,
889: p_msg_level=>fnd_log.level_procedure);
890: hz_utility_v2pub.debug(

Line 890: hz_utility_v2pub.debug(

886: hz_utility_v2pub.debug(
887: p_message=>'storing the right paranthesis. details of the hashmap',
888: p_prefix=>l_debug_prefix,
889: p_msg_level=>fnd_log.level_procedure);
890: hz_utility_v2pub.debug(
891: p_message=>'rec:'||l_rpc||'BOCODE:'||l_node_tbl(i).BO_CODE||':parentnode: '||(i-1)||':PARENTBO:'||l_node_tbl(i).PARENT_BO_CODE,
892: p_prefix=>l_debug_prefix,
893: p_msg_level=>fnd_log.level_procedure);
894: END IF;

Line 908: hz_utility_v2pub.debug(

904: WHEN ((l_node_tbl(i-1).BO_CODE = l_node_tbl(i).PARENT_BO_CODE) AND
905: (l_node_tbl(i-1).RNF = 'N' )) THEN
906: l2i(l_rp||'--'||l_node_tbl(i-1).entity_name);
907: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
908: hz_utility_v2pub.debug(
909: p_message=>'for node: '||i|| 'is the type 1 sibling of:'||l_node_tbl(i).PARENT_BO_CODE,
910: p_prefix=>l_debug_prefix,
911: p_msg_level=>fnd_log.level_procedure);
912: END IF;

Line 926: hz_utility_v2pub.debug(

922: (l_node_tbl(i-1).BO_CODE = l_node_tbl(i).BO_CODE) AND
923: (l_node_tbl(i-1).RNF = 'N')) THEN
924: l2i(l_rp||'--'||l_node_tbl(i-1).entity_name);
925: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
926: hz_utility_v2pub.debug(
927: p_message=>'node: '||i|| 'is the type 2 sibling of node:'||(i-1)||'and its parent bo is:'||l_node_tbl(i).PARENT_BO_CODE,
928: p_prefix=>l_debug_prefix,
929: p_msg_level=>fnd_log.level_procedure);
930: END IF;

Line 945: hz_utility_v2pub.debug(

941: (l_node_tbl(i-1).BO_CODE <> l_node_tbl(i).BO_CODE) AND
942: (l_node_tbl(i-1).RNF = 'Y')) THEN
943: l2i(l_rp||'--'||l_node_tbl(i-1).entity_name);
944: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
945: hz_utility_v2pub.debug(
946: p_message=>'node: '||i||' is the type 3 sibling of:'||(i-1)||' and its parent bo is:'||l_node_tbl(i).PARENT_BO_CODE,
947: p_prefix=>l_debug_prefix,
948: p_msg_level=>fnd_log.level_procedure);
949: END IF;

Line 965: hz_utility_v2pub.debug(

961: -- in node_tbl will have left parnthesis in its global variable
962: l2i(l_rp||' --'||l_node_tbl(i-1).entity_name);
963:
964: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
965: hz_utility_v2pub.debug(
966: p_message=>'previous node is neither the parent nor sibling of node:'||i,
967: p_prefix=>l_debug_prefix,
968: p_msg_level=>fnd_log.level_procedure);
969: hz_utility_v2pub.debug(

Line 969: hz_utility_v2pub.debug(

965: hz_utility_v2pub.debug(
966: p_message=>'previous node is neither the parent nor sibling of node:'||i,
967: p_prefix=>l_debug_prefix,
968: p_msg_level=>fnd_log.level_procedure);
969: hz_utility_v2pub.debug(
970: p_message=>'node: '||i|| 'is not a parent or sibling of node:'||(i-1)||' and its parent bo:'||l_node_tbl(i).PARENT_BO_CODE,
971: p_prefix=>l_debug_prefix,
972: p_msg_level=>fnd_log.level_procedure);
973: hz_utility_v2pub.debug(

Line 973: hz_utility_v2pub.debug(

969: hz_utility_v2pub.debug(
970: p_message=>'node: '||i|| 'is not a parent or sibling of node:'||(i-1)||' and its parent bo:'||l_node_tbl(i).PARENT_BO_CODE,
971: p_prefix=>l_debug_prefix,
972: p_msg_level=>fnd_log.level_procedure);
973: hz_utility_v2pub.debug(
974: p_message=>'number of right paranthesis collected so far:'||l_rpc,
975: p_prefix=>l_debug_prefix,
976: p_msg_level=>fnd_log.level_procedure);
977: END IF;

Line 2356: hz_utility_v2pub.debug(

2352: END CASE; -- end of CASE for figuring out the entity name to get right SQL
2353: END LOOP; -- end of looping through hierarchy of collection.
2354:
2355: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2356: hz_utility_v2pub.debug(
2357: p_message=>'all the sql segments were identified',
2358: p_prefix=>l_debug_prefix,
2359: p_msg_level=>fnd_log.level_procedure);
2360: END IF;

Line 2395: hz_utility_v2pub.debug(p_message=>'GENBOSQL()-',

2391: l2i('; -- cursor for '||P_SQL_FOR||' SQL');
2392:
2393: COMMIT;
2394: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2395: hz_utility_v2pub.debug(p_message=>'GENBOSQL()-',
2396: p_prefix=>l_debug_prefix,
2397: p_msg_level=>fnd_log.level_procedure);
2398: END IF;
2399: P_STATUS := TRUE; -- this means sql generation is successfull

Line 2404: hz_utility_v2pub.debug(

2400: /*
2401: EXCEPTION
2402: WHEN others THEN
2403: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2404: hz_utility_v2pub.debug(
2405: p_message=>'in excp block of genBOSQL()'||SQLERRM,
2406: p_prefix=>l_debug_prefix,
2407: p_msg_level=>fnd_log.level_procedure);
2408: END IF;

Line 2434: hz_utility_v2pub.debug(p_message=>'genCompletenessProc ()+',

2430: l_param_name VARCHAR2(30) := 'P_BO_CODE';
2431:
2432: BEGIN
2433: if fnd_log.level_procedure>=fnd_log.g_current_runtime_level then
2434: hz_utility_v2pub.debug(p_message=>'genCompletenessProc ()+',
2435: p_prefix=>l_prefix,
2436: p_msg_level=>fnd_log.level_procedure);
2437: end if;
2438: /*

Line 2509: hz_utility_v2pub.debug(

2505: li('END IF; -- end of check for '||G_PER_BO_CODE);
2506: ELSE
2507: l_msg := 'Unable to generate the completeness() del stmt for PERSON BO';
2508: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2509: hz_utility_v2pub.debug(
2510: p_message=>l_msg,
2511: p_prefix=>l_prefix,
2512: p_msg_level=>fnd_log.level_procedure);
2513: END IF;

Line 2538: hz_utility_v2pub.debug(

2534: li('END IF; -- end of check for '||G_ORG_BO_CODE);
2535: ELSE
2536: l_msg := 'Unable to generate the completeness() del stmt for '||G_ORG_BO_CODE||' BO';
2537: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2538: hz_utility_v2pub.debug(
2539: p_message=>l_msg,
2540: p_prefix=>l_prefix,
2541: p_msg_level=>fnd_log.level_procedure);
2542: END IF;

Line 2567: hz_utility_v2pub.debug(

2563: li('END IF; -- end of check for '||G_PER_CUST_BO_CODE);
2564: ELSE
2565: l_msg := 'Unable to generate the completeness() del stmt for '||G_PER_CUST_BO_CODE||' BO';
2566: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2567: hz_utility_v2pub.debug(
2568: p_message=>l_msg,
2569: p_prefix=>l_prefix,
2570: p_msg_level=>fnd_log.level_procedure);
2571: END IF;

Line 2596: hz_utility_v2pub.debug(

2592: li('END IF; -- end of check for '||G_PER_CUST_BO_CODE);
2593: ELSE
2594: l_msg := 'Unable to generate the completeness() del stmt for '||G_ORG_CUST_BO_CODE||' BO';
2595: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2596: hz_utility_v2pub.debug(
2597: p_message=>l_msg,
2598: p_prefix=>l_prefix,
2599: p_msg_level=>fnd_log.level_procedure);
2600: END IF;

Line 2615: hz_utility_v2pub.DEBUG (

2611: writeDebugMesg(l_msg, l_gen_prefix);
2612:
2613: procEnd(l_procName);
2614: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2615: hz_utility_v2pub.DEBUG (
2616: p_message=>'genCompletenessProc()-',
2617: p_prefix=>l_prefix,
2618: p_msg_level=>fnd_log.level_procedure);
2619: END IF;

Line 2643: hz_utility_v2pub.debug(p_message=>'genEvtTypeProc()+',

2639: l_param_name VARCHAR2(30) := 'P_BO_CODE';
2640:
2641: BEGIN
2642: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2643: hz_utility_v2pub.debug(p_message=>'genEvtTypeProc()+',
2644: p_prefix=>l_prefix,
2645: p_msg_level=>fnd_log.level_procedure);
2646: END IF;
2647:

Line 2709: hz_utility_v2pub.debug(

2705: li('END IF; -- end of check for '||G_PER_BO_CODE);
2706: ELSE
2707: l_msg := 'Unable to generate the evt type upd stmt for PERSON BO';
2708: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2709: hz_utility_v2pub.debug(
2710: p_message=>l_msg,
2711: p_prefix=>l_prefix,
2712: p_msg_level=>fnd_log.level_procedure);
2713: END IF;

Line 2736: hz_utility_v2pub.debug(

2732: li('END IF; -- end of check for '||G_ORG_BO_CODE);
2733: ELSE
2734: l_msg := 'Unable to generate the evt type upd stmt for Org BO';
2735: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2736: hz_utility_v2pub.debug(
2737: p_message=>l_msg,
2738: p_prefix=>l_prefix,
2739: p_msg_level=>fnd_log.level_procedure);
2740: END IF;

Line 2761: hz_utility_v2pub.debug(

2757: li('END IF; -- end of check for '||G_PER_CUST_BO_CODE);
2758: ELSE
2759: l_msg := 'Unable to generate the evt type upd stmt for Person Customer BO';
2760: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2761: hz_utility_v2pub.debug(
2762: p_message=>l_msg,
2763: p_prefix=>l_prefix,
2764: p_msg_level=>fnd_log.level_procedure);
2765: END IF;

Line 2786: hz_utility_v2pub.debug(

2782: li('END IF; -- end of check for '||G_ORG_CUST_BO_CODE);
2783: ELSE
2784: l_msg := 'Unable to generate the evt type upd stmt for Person Customer BO';
2785: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2786: hz_utility_v2pub.debug(
2787: p_message=>l_msg,
2788: p_prefix=>l_prefix,
2789: p_msg_level=>fnd_log.level_procedure);
2790: END IF;

Line 2804: hz_utility_v2pub.DEBUG (

2800: writeDebugMesg(l_msg, l_gen_prefix);
2801:
2802: procEnd(l_procName);
2803: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2804: hz_utility_v2pub.DEBUG (
2805: p_message=>'genEvtTypeProc()-',
2806: p_prefix=>l_prefix,
2807: p_msg_level=>fnd_log.level_procedure);
2808: END IF;

Line 2828: hz_utility_v2pub.debug(p_message=>'gen_pkg_body()+',

2824: l_debug_prefix VARCHAR2(15) := 'GENPKG:';
2825: l_pkg_name VARCHAR2(30) := 'HZ_BES_BO_SITE_UTIL_PKG';
2826: BEGIN -- gen_pkg_body
2827: if fnd_log.level_procedure>=fnd_log.g_current_runtime_level then
2828: hz_utility_v2pub.debug(p_message=>'gen_pkg_body()+',
2829: p_prefix=>l_debug_prefix,
2830: p_msg_level=>fnd_log.level_procedure);
2831: end if;
2832:

Line 2849: hz_utility_v2pub.debug(p_message=>'gen_pkg_body()-',

2845:
2846: COMMIT;
2847: P_STATUS := TRUE; -- assigning the return status to success
2848: if fnd_log.level_procedure>=fnd_log.g_current_runtime_level then
2849: hz_utility_v2pub.debug(p_message=>'gen_pkg_body()-',
2850: p_prefix=>l_debug_prefix,
2851: p_msg_level=>fnd_log.level_procedure);
2852: END IF;
2853: