APPS.PA_PROJECT_SETS_PVT dependencies on PA_PROJECT_SET_UTILS

Line 53: PA_PROJECT_SET_UTILS.Check_PartyName_Or_Id (

49: ,x_log_level => 5);
50: END IF;
51: -- have to get the party_id of the owner if party_id passed in is NULL
52: IF p_party_id IS NULL THEN
53: PA_PROJECT_SET_UTILS.Check_PartyName_Or_Id (
54: p_party_id => p_party_id,
55: p_party_name => p_party_name,
56: p_check_id_flag => 'Y',
57: x_party_id => l_party_id,

Line 68: l_unique := PA_PROJECT_SET_UTILS.is_name_unique(p_project_set_name);

64: ,p_msg_name => l_msg_data);
65: END IF;
66:
67: -- perform a check that the project set name must be unique
68: l_unique := PA_PROJECT_SET_UTILS.is_name_unique(p_project_set_name);
69:
70: IF l_unique = 'N' THEN
71: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
72: ,p_msg_name => 'PA_PROJECT_SET_NAME_NOT_UNIQUE');

Line 198: PA_PROJECT_SET_UTILS.Check_PartyName_Or_Id (

194: END IF;
195:
196: -- have to get the party_id of the owner if party_id passed in is NULL
197: IF p_party_id IS NULL THEN
198: PA_PROJECT_SET_UTILS.Check_PartyName_Or_Id (
199: p_party_id => p_party_id,
200: p_party_name => p_party_name,
201: p_check_id_flag => 'Y',
202: x_party_id => l_party_id,

Line 212: l_unique := PA_PROJECT_SET_UTILS.is_name_unique(p_project_set_name, p_project_set_id);

208: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
209: ,p_msg_name => l_msg_data);
210: END IF;
211:
212: l_unique := PA_PROJECT_SET_UTILS.is_name_unique(p_project_set_name, p_project_set_id);
213:
214: IF l_unique = 'N' THEN
215: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
216: ,p_msg_name => 'PA_PROJECT_SET_NAME_NOT_UNIQUE');

Line 288: l_project_set_lines_tbl pa_project_set_utils.project_set_lines_tbl_type;

284: )
285: IS
286: l_return_status VARCHAR2(1);
287: l_do_lines_exist VARCHAR2(1);
288: l_project_set_lines_tbl pa_project_set_utils.project_set_lines_tbl_type;
289: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
290:
291: BEGIN
292:

Line 303: l_project_set_lines_tbl := pa_project_set_utils.get_project_set_lines(p_project_set_id => p_project_set_id);

299: ,x_msg => 'Beginning of Delete_Project_Set pvt'
300: ,x_log_level => 5);
301: END IF;
302:
303: l_project_set_lines_tbl := pa_project_set_utils.get_project_set_lines(p_project_set_id => p_project_set_id);
304:
305: IF l_project_set_lines_tbl.COUNT > 0 THEN
306:
307: FOR i IN l_project_set_lines_tbl.FIRST .. l_project_set_lines_tbl.LAST LOOP

Line 319: l_do_lines_exist := PA_PROJECT_SET_UTILS.do_lines_exist(p_project_set_id);

315: END IF;
316:
317: IF FND_MSG_PUB.Count_Msg = 0 THEN
318:
319: l_do_lines_exist := PA_PROJECT_SET_UTILS.do_lines_exist(p_project_set_id);
320:
321: IF l_do_lines_exist = 'N' THEN
322:
323: PA_PROJECT_SETS_PKG.delete_row

Line 379: l_exists := PA_PROJECT_SET_UTILS.check_projects_in_set(

375: FROM pa_project_sets_b
376: WHERE project_set_id = p_project_set_id
377: FOR UPDATE NOWAIT;
378:
379: l_exists := PA_PROJECT_SET_UTILS.check_projects_in_set(
380: p_project_set_id => p_project_set_id
381: ,p_project_id => p_project_id);
382:
383: IF l_exists = 'N' THEN

Line 428: l_exists := PA_PROJECT_SET_UTILS.check_projects_in_set(

424: ,x_msg => 'Beginning of Delete_Project_Set_Line pvt'
425: ,x_log_level => 5);
426: END IF;
427:
428: l_exists := PA_PROJECT_SET_UTILS.check_projects_in_set(
429: p_project_set_id => p_project_set_id
430: ,p_project_id => p_project_id);
431:
432: IF l_exists = 'Y' THEN