DBA Data[Home] [Help]

APPS.PA_RESOURCE_SETUP_PVT dependencies on PA_UTILS

Line 74: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

70: FOR UPDATE OF record_version_number NOWAIT;
71:
72: EXCEPTION WHEN TIMEOUT_ON_RESOURCE THEN
73:
74: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
75: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
76: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
77: x_return_status := 'E' ;
78:

Line 81: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

77: x_return_status := 'E' ;
78:
79: WHEN NO_DATA_FOUND THEN
80:
81: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
82: p_msg_name => 'PA_XC_RECORD_CHANGED');
83: x_msg_data := 'PA_XC_RECORD_CHANGED';
84: x_return_status := 'E' ;
85:

Line 89: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

85:
86: WHEN OTHERS THEN
87:
88: IF SQLCODE = -54 THEN
89: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
90: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
91: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
92: x_return_status := 'E' ;
93: ELSE

Line 107: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

103: WHERE project_id = p_project_id
104: AND record_version_number = p_record_version_number;
105: EXCEPTION
106: WHEN NO_DATA_FOUND THEN
107: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
108: p_msg_name => 'PA_XC_RECORD_CHANGED');
109: x_msg_data := 'PA_XC_RECORD_CHANGED';
110: x_return_status := 'E' ;
111: WHEN OTHERS THEN

Line 113: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

109: x_msg_data := 'PA_XC_RECORD_CHANGED';
110: x_return_status := 'E' ;
111: WHEN OTHERS THEN
112: IF SQLCODE = -54 THEN
113: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
114: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
115: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
116: x_return_status := 'E' ;
117: Else