APPS.PA_RESOURCE_MAPPING dependencies on PA_DEBUG

Line 686: PA_DEBUG.init_err_stack('identify_new_plan_res');

682: l_src_table VARCHAR2(20) := 'PA_RES_LIST_MAP_TMP1';
683:
684: BEGIN
685:
686: PA_DEBUG.init_err_stack('identify_new_plan_res');
687:
688: --Generate SQL statement to populate TMP3
689: --This step differentiates the mapped and
690: --unmapped headers

Line 704: pa_debug.reset_err_stack;

700:
701: EXECUTE IMMEDIATE 'BEGIN ' ||l_SQL_statement || ' END;';
702: l_SQL_statement := NULL; --reset SQL statement
703:
704: pa_debug.reset_err_stack;
705:
706: RETURN 0;
707:
708: END;--end function identify_new_plan_res

Line 795: PA_DEBUG.init_err_stack('create_planning_resource');

791:
792: -- Initialize the return status to success
793: x_return_status := FND_API.G_RET_STS_SUCCESS;
794:
795: PA_DEBUG.init_err_stack('create_planning_resource');
796:
797: --Create missing planning resources in
798: --PA_RESOURCE_LIST_MEMBERS
799: FOR planning_res_rec IN new_planning_resources(p_resource_class_id) LOOP

Line 879: pa_debug.reset_err_stack;

875: END IF;
876:
877: END LOOP;
878:
879: pa_debug.reset_err_stack;
880:
881: END; --end procedure create_planning_resources
882:
883: -----------------------------------------------

Line 902: PA_DEBUG.init_err_stack('process_mapped_txns');

898: l_src_table VARCHAR2(20) := 'pa_res_list_map_tmp1';
899:
900: BEGIN
901:
902: PA_DEBUG.init_err_stack('process_mapped_txns');
903:
904: --Move mapped txns to TMP4
905: --Truncate TMP3 (It will be used to
906: --map remaining txns)

Line 924: pa_debug.reset_err_stack;

920: --
921: -- Replaced truncate statement with delete for resolving the auto commit issue.
922: --EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || get_pa_schema_name || '.PA_RES_LIST_MAP_TMP3');
923: EXECUTE IMMEDIATE ('DELETE FROM ' || get_pa_schema_name || '.PA_RES_LIST_MAP_TMP3');
924: pa_debug.reset_err_stack;
925:
926: RETURN 0;
927:
928: END;--end function process_mapped_txns

Line 936: PA_DEBUG.init_err_stack('process_txns_for_next_format');

932: -----------------------------------------
933: FUNCTION process_txns_for_next_format RETURN NUMBER IS
934: BEGIN
935:
936: PA_DEBUG.init_err_stack('process_txns_for_next_format');
937:
938: --Move txns that did not satisfy format
939: --to TMP2/TMP1 based on the run sequence
940: --Truncate processed txns in TMP1/TMP2

Line 946: pa_debug.reset_err_stack;

942: -- As part of bug fix we are deleting all the records from TEMP1 that exists in
943: -- TEMP4
944: EXECUTE IMMEDIATE ('DELETE FROM ' || get_pa_schema_name || '.PA_RES_LIST_MAP_TMP1 TMP1' || ' WHERE ROWID IN ( SELECT tmp_rowid FROM pa_res_list_map_tmp4 tmp4 WHERE tmp4.tmp_rowid = tmp1.rowid ) ');
945:
946: pa_debug.reset_err_stack;
947:
948: RETURN 0;
949:
950: END;--end function process_txns_for_next_format

Line 977: PA_DEBUG.init_err_stack('map_for_format');

973:
974: -- Initialize the return status to success
975: x_return_status := FND_API.G_RET_STS_SUCCESS;
976:
977: PA_DEBUG.init_err_stack('map_for_format');
978:
979: --Identify new planning resources that need to be created
980: --Generate SQL for TMP3
981: l_status := identify_new_plan_res (p_resource_class_id, p_format_id);

Line 1027: pa_debug.reset_err_stack;

1023: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1024: RETURN;
1025: END IF;
1026:
1027: pa_debug.reset_err_stack;
1028:
1029: END; --end procedure map_for_format
1030:
1031: