eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PROJECT_STRUCTURE_PVT1 dependencies on PA_UTILS

Line 176: PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_STRUC_NAME_UNIQUE');

172: If (pa_project_structure_utils.check_structure_name_unique(p_structure_name,
173: NULL,
174: p_project_id) <> 'Y') THEN
175: --Name is not unique
176: PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_STRUC_NAME_UNIQUE');
177: x_msg_data := 'PA_PS_STRUC_NAME_UNIQUE';
178: RAISE FND_API.G_EXC_ERROR;
179: END IF;
180:

Line 189: PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_PROJ_MANAG_NOT_LIC');

185: IF (p_calling_flag IS NOT NULL) THEN
186: IF (p_calling_flag = 'WORKPLAN') THEN
187: l_financial_license := 'N';
188: IF (l_workplan_license = 'N') THEN
189: PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_PROJ_MANAG_NOT_LIC');
190: x_msg_data := 'PA_PS_PROD_MANAG_NOT_LIC';
191: RAISE FND_API.G_EXC_ERROR;
192: END IF;
193: ELSIF (p_calling_flag = 'FINANCIAL') THEN

Line 196: PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_COSTING_NOT_LIC');

192: END IF;
193: ELSIF (p_calling_flag = 'FINANCIAL') THEN
194: l_workplan_license := 'N';
195: IF (l_financial_license <> 'Y') THEN
196: PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_COSTING_NOT_LIC');
197: RAISE FND_API.G_EXC_ERROR;
198: END IF;
199: ELSIF (p_calling_flag = 'DELIVERABLE') THEN
200: l_workplan_license := 'N';

Line 211: PA_UTILS.ADD_MESSAGE('PA', 'PA_INVALID_PROJECT_ID');

207: --Check if we should split structure types into different structure
208: open get_split_flag;
209: fetch get_split_flag into l_split_flag, l_split_flag2;
210: IF get_split_flag%NOTFOUND THEN
211: PA_UTILS.ADD_MESSAGE('PA', 'PA_INVALID_PROJECT_ID');
212: x_msg_data := 'PA_INVALID_PROJECT_ID';
213: RAISE FND_API.G_EXC_ERROR;
214: END IF;
215: close get_split_flag;

Line 233: PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_PROJ_MANAG_NOT_LIC');

229: IF (p_calling_flag = 'WORKPLAN') THEN
230: l_costing_license := 'N';
231: l_billing_license := 'N';
232: If (l_workplan_license <> 'Y') THEN
233: PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_PROJ_MANAG_NOT_LIC');
234: x_msg_data := 'PA_PS_PROD_MANAG_NOT_LIC';
235: RAISE FND_API.G_EXC_ERROR;
236: END IF;
237: ELSIf (p_calling_flag = 'COSTING') THEN

Line 239: PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_COSTING_NOT_LIC');

235: RAISE FND_API.G_EXC_ERROR;
236: END IF;
237: ELSIf (p_calling_flag = 'COSTING') THEN
238: IF (l_costing_license <> 'Y') THEN
239: PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_COSTING_NOT_LIC');
240: x_msg_data := 'PA_PS_COSTING_NOT_LIC';
241: RAISE FND_API.G_EXC_ERROR;
242: END IF;
243: l_workplan_license := 'N';

Line 249: PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_BILLING_NOT_LIC');

245: l_billing_license := 'N';
246: END IF;
247: ELSIf (p_calling_flag = 'BILLING') THEN
248: IF (l_billing_license <> 'Y') THEN
249: PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_BILLING_NOT_LIC');
250: x_msg_data := 'PA_PS_BILLING_NOT_LIC';
251: RAISE FND_API.G_EXC_ERROR;
252: END IF;
253: l_workplan_license := 'N';

Line 258: PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_NO_CALLING_PAGE_SEL');

254: If (l_split_flag2 <> 'N') THEN
255: l_costing_license := 'N';
256: END IF;
257: ELSIf (p_calling_flag IS NULL) THEN
258: PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_NO_CALLING_PAGE_SEL');
259: x_msg_data := 'PA_PS_NO_CALLING_PAGE_SEL';
260: RAISE FND_API.G_EXC_ERROR;
261: END IF;
262: END IF;

Line 415: PA_UTILS.ADD_MESSAGE('PA',l_error_message_code);

411: l_return_status,
412: l_error_message_code);
413: --dbms_output.put_line(l_return_status||', '||l_error_message_code);
414: If (l_return_status <> 'S') THEN
415: PA_UTILS.ADD_MESSAGE('PA',l_error_message_code);
416: x_msg_data := l_error_message_code;
417: CLOSE get_licensed;
418: RAISE FND_API.G_EXC_ERROR;
419: END IF;

Line 1024: PA_UTILS.ADD_MESSAGE('PA','PA_PS_STRUC_VER_NAM_UNIQUE');

1020: IF ('Y' <> PA_PROJECT_STRUCTURE_UTILS.Check_Struc_Ver_Name_Unique(p_structure_version_name,
1021: null,
1022: l_project_id,
1023: l_proj_element_id)) THEN
1024: PA_UTILS.ADD_MESSAGE('PA','PA_PS_STRUC_VER_NAM_UNIQUE');
1025: x_msg_data := 'PA_PS_STRUC_VER_NAM_UNIQUE';
1026: RAISE FND_API.G_EXC_ERROR;
1027: END IF;
1028:

Line 1202: PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_ONE_WORK_VER_ALLOWED');

1198: If check_working_ver_exists%FOUND THEN
1199:
1200: --another non-published version exists for structure with type = costing/billing.
1201: --Error.
1202: PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_ONE_WORK_VER_ALLOWED');
1203: x_msg_data := 'PA_PS_ONE_WORK_VER_ALLOWED';
1204: RAISE FND_API.G_EXC_ERROR;
1205: END IF;
1206: CLOSE check_working_ver_exists;

Line 1509: PA_UTILS.ADD_MESSAGE('PA','PA_PS_STRUC_NOT_EXIST');

1505: l_attribute13,
1506: l_attribute14,
1507: l_attribute15;
1508: IF (get_struc%NOTFOUND) THEN
1509: PA_UTILS.ADD_MESSAGE('PA','PA_PS_STRUC_NOT_EXIST');
1510: x_msg_data := 'PA_PS_STRUC_NOT_EXIST';
1511: RAISE FND_API.G_EXC_ERROR;
1512: END IF;
1513: CLOSE get_struc;

Line 1540: PA_UTILS.ADD_MESSAGE('PA', 'PS_STRUC_NAME_UNIQUE');

1536: IF ('Y' <> pa_project_structure_utils.Check_Structure_Name_Unique(p_structure_name,
1537: p_structure_id,
1538: l_project_id)) THEN
1539: --name not unique.
1540: PA_UTILS.ADD_MESSAGE('PA', 'PS_STRUC_NAME_UNIQUE');
1541: x_msg_data := 'PA_PS_STRUC_NAME_UNIQUE';
1542: RAISE FND_API.G_EXC_ERROR;
1543: ELSE
1544: l_name := p_structure_name;

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

1914: and record_version_number = p_record_version_number
1915: for update NOWAIT;
1916: EXCEPTION
1917: when TIMEOUT_ON_RESOURCE then
1918: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1919: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
1920: l_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
1921: when NO_DATA_FOUND then
1922: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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

1918: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1919: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
1920: l_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
1921: when NO_DATA_FOUND then
1922: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1923: p_msg_name => 'PA_XC_RECORD_CHANGED');
1924: l_msg_data := 'PA_XC_RECORD_CHANGED';
1925: when OTHERS then
1926: if SQLCODE = -54 then

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

1923: p_msg_name => 'PA_XC_RECORD_CHANGED');
1924: l_msg_data := 'PA_XC_RECORD_CHANGED';
1925: when OTHERS then
1926: if SQLCODE = -54 then
1927: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1928: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
1929: l_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
1930: else
1931: raise;

Line 2043: PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_STRUC_VER_LOCKED');

2039: --end bug 3071008
2040:
2041: IF (l_get_lock = 'O') THEN
2042: --lock by other user. Error.
2043: PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_STRUC_VER_LOCKED');
2044: x_msg_data := 'PA_PS_STRUC_VER_LOCKED';
2045: RAISE FND_API.G_EXC_ERROR;
2046: END IF;
2047:

Line 2064: PA_UTILS.ADD_MESSAGE('PA','PA_PS_STRUC_VER_NAM_UNIQUE');

2060: IF ('Y' <> PA_PROJECT_STRUCTURE_UTILS.Check_Struc_Ver_Name_Unique(p_structure_version_name,
2061: p_pev_structure_id,
2062: l_project_id,
2063: l_proj_element_id)) THEN
2064: PA_UTILS.ADD_MESSAGE('PA','PA_PS_STRUC_VER_NAM_UNIQUE');
2065: x_msg_data := 'PA_PS_STRUC_VER_NAM_UNIQUE';
2066: RAISE FND_API.G_EXC_ERROR;
2067: ELSE
2068: l_name := p_structure_version_name;

Line 2083: PA_UTILS.ADD_MESSAGE('PA','PA_PS_STRUC_VER_NAM_UNIQUE');

2079: IF ('Y' <> PA_PROJECT_STRUCTURE_UTILS.Check_Struc_Ver_Name_Unique(p_structure_version_name,
2080: p_pev_structure_id,
2081: l_project_id,
2082: l_proj_element_id)) THEN
2083: PA_UTILS.ADD_MESSAGE('PA','PA_PS_STRUC_VER_NAM_UNIQUE');
2084: x_msg_data := 'PA_PS_STRUC_VER_NAM_UNIQUE';
2085: RAISE FND_API.G_EXC_ERROR;
2086: ELSE
2087: l_name := p_structure_version_name;

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

2388: and record_version_number = p_record_version_number
2389: for update of record_version_number NOWAIT;
2390: EXCEPTION
2391: when TIMEOUT_ON_RESOURCE then
2392: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2393: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
2394: l_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
2395: when NO_DATA_FOUND then
2396: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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

2392: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2393: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
2394: l_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
2395: when NO_DATA_FOUND then
2396: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2397: p_msg_name => 'PA_XC_RECORD_CHANGED');
2398: l_msg_data := 'PA_XC_RECORD_CHANGED';
2399: when OTHERS then
2400: if SQLCODE = -54 then

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

2397: p_msg_name => 'PA_XC_RECORD_CHANGED');
2398: l_msg_data := 'PA_XC_RECORD_CHANGED';
2399: when OTHERS then
2400: if SQLCODE = -54 then
2401: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2402: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
2403: l_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
2404: else
2405: raise;

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

2412: where proj_element_id = p_structure_id
2413: and record_version_number = p_record_version_number;
2414: EXCEPTION
2415: when NO_DATA_FOUND then
2416: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2417: p_msg_name => 'PA_XC_RECORD_CHANGED');
2418: l_msg_data := 'PA_XC_RECORD_CHANGED';
2419: when OTHERS then
2420: raise;

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

2544: and record_version_number = p_record_version_number
2545: for update of record_version_number NOWAIT;
2546: EXCEPTION
2547: when TIMEOUT_ON_RESOURCE then
2548: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2549: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
2550: l_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
2551: when NO_DATA_FOUND then
2552: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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

2548: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2549: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
2550: l_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
2551: when NO_DATA_FOUND then
2552: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2553: p_msg_name => 'PA_XC_RECORD_CHANGED');
2554: l_msg_data := 'PA_XC_RECORD_CHANGED';
2555: when OTHERS then
2556: if SQLCODE = -54 then

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

2553: p_msg_name => 'PA_XC_RECORD_CHANGED');
2554: l_msg_data := 'PA_XC_RECORD_CHANGED';
2555: when OTHERS then
2556: if SQLCODE = -54 then
2557: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2558: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
2559: l_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
2560: else
2561: raise;

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

2568: where element_version_id = p_structure_version_id
2569: and record_version_number = p_record_version_number;
2570: EXCEPTION
2571: when NO_DATA_FOUND then
2572: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2573: p_msg_name => 'PA_XC_RECORD_CHANGED');
2574: l_msg_data := 'PA_XC_RECORD_CHANGED';
2575: when OTHERS then
2576: raise;

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

2817: and record_version_number = p_record_version_number
2818: for update of record_version_number NOWAIT;
2819: EXCEPTION
2820: when TIMEOUT_ON_RESOURCE then
2821: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2822: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
2823: l_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
2824: when NO_DATA_FOUND then
2825: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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

2821: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2822: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
2823: l_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
2824: when NO_DATA_FOUND then
2825: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2826: p_msg_name => 'PA_XC_RECORD_CHANGED');
2827: l_msg_data := 'PA_XC_RECORD_CHANGED';
2828: when OTHERS then
2829: if SQLCODE = -54 then

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

2826: p_msg_name => 'PA_XC_RECORD_CHANGED');
2827: l_msg_data := 'PA_XC_RECORD_CHANGED';
2828: when OTHERS then
2829: if SQLCODE = -54 then
2830: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2831: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
2832: l_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
2833: else
2834: raise;

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

2841: where pev_structure_id = p_pev_structure_id
2842: and record_version_number = p_record_version_number;
2843: EXCEPTION
2844: when NO_DATA_FOUND then
2845: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2846: p_msg_name => 'PA_XC_RECORD_CHANGED');
2847: l_msg_data := 'PA_XC_RECORD_CHANGED';
2848: when OTHERS then
2849: raise;

Line 3333: PA_UTILS.ADD_MESSAGE('PA','PA_PS_NEED_THIRD_PT_SCH');

3329: --bug 3840509
3330: IF 'Y' = nvl(PA_PROJECT_STRUCTURE_UTILS.Get_Sch_Dirty_fl(l_project_id,
3331: p_structure_version_id), 'N') THEN
3332: --need to reschedule
3333: PA_UTILS.ADD_MESSAGE('PA','PA_PS_NEED_THIRD_PT_SCH');
3334: x_msg_data := 'PA_PS_NEED_THIRD_PT_SCH';
3335: RAISE FND_API.G_EXC_ERROR;
3336: END IF;
3337: --end bug 3840509

Line 3370: -- PA_UTILS.ADD_MESSAGE('PA','PA_PS_MISS_TRANSAC_TASK');

3366:
3367: --hsiu: bug 2684465
3368: --Check if this structure missing tasks with transactions
3369: -- IF ('Y' <> PA_PROJECT_STRUCTURE_UTILS.check_miss_transaction_tasks(p_structure_version_id)) THEN
3370: -- PA_UTILS.ADD_MESSAGE('PA','PA_PS_MISS_TRANSAC_TASK');
3371: -- x_msg_data := 'PA_PS_MISS_TRANSAC_TASK';
3372: -- RAISE FND_API.G_EXC_ERROR;
3373: -- END IF;
3374: PA_PROJECT_STRUCTURE_UTILS.CHECK_MISS_TRANSACTION_TASKS(p_structure_version_id,

Line 3401: PA_UTILS.ADD_MESSAGE('PA',l_error_message_code);

3397: ,l_msg_count
3398: ,l_msg_data
3399: );
3400: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3401: PA_UTILS.ADD_MESSAGE('PA',l_error_message_code);
3402: x_msg_data := l_error_message_code;
3403: RAISE FND_API.G_EXC_ERROR;
3404: END IF;
3405: --end bug 2684465

Line 3430: -- PA_UTILS.ADD_MESSAGE('PA','PA_PS_LINK_STRUC_NOT_PUB');

3426: END IF;
3427:
3428: --Check if this structure can be published (ie, if linked structures are published)
3429: -- IF ('Y' <> PA_PROJECT_STRUCTURE_UTILS.Check_Publish_Struc_Ver_Ok(p_structure_version_id)) THEN
3430: -- PA_UTILS.ADD_MESSAGE('PA','PA_PS_LINK_STRUC_NOT_PUB');
3431: -- x_msg_data := 'PA_PS_LINK_STRUC_NOT_PUB';
3432: -- RAISE FND_API.G_EXC_ERROR;
3433: -- END IF;
3434:

Line 3437: -- PA_UTILS.ADD_MESSAGE('PA','PA_PS_MISS_TRANSAC_TASK');

3433: -- END IF;
3434:
3435: --Check if this structure missing tasks with transactions
3436: -- IF ('Y' <> PA_PROJECT_STRUCTURE_UTILS.check_miss_transaction_tasks(p_structure_version_id)) THEN
3437: -- PA_UTILS.ADD_MESSAGE('PA','PA_PS_MISS_TRANSAC_TASK');
3438: -- x_msg_data := 'PA_PS_MISS_TRANSAC_TASK';
3439: -- RAISE FND_API.G_EXC_ERROR;
3440: -- END IF;
3441:

Line 3547: pa_utils.add_message('PA','PA_PS_NEW_STRUC_VER_NAM_UNIQUE');

3543: l_project_id,
3544: l_proj_element_id) <> 'Y') THEN
3545:
3546: --Not unique; error.
3547: pa_utils.add_message('PA','PA_PS_NEW_STRUC_VER_NAM_UNIQUE');
3548: x_msg_data := 'PA_PS_NEW_STRUC_VER_NAM_UNIQUE';
3549: RAISE FND_API.G_EXC_ERROR;
3550: END IF;
3551:

Line 3569: PA_UTILS.ADD_MESSAGE('PA','PA_PS_STRUC_VER_NAM_UNIQUE');

3565: null,
3566: l_project_id,
3567: l_proj_element_id) <> 'Y') THEN
3568: --Not unique; error.
3569: PA_UTILS.ADD_MESSAGE('PA','PA_PS_STRUC_VER_NAM_UNIQUE');
3570: x_msg_data := 'PA_PS_STRUC_VER_NAM_UNIQUE';
3571: RAISE FND_API.G_EXC_ERROR;
3572: END IF;
3573: --Bug No 3450684 Smukka Checking for deliverable type

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

3571: RAISE FND_API.G_EXC_ERROR;
3572: END IF;
3573: --Bug No 3450684 Smukka Checking for deliverable type
3574: IF PA_PROJ_ELEMENTS_UTILS.check_sharedstruct_deliv(p_structure_version_id) = 'Y' THEN
3575: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3576: p_msg_name => 'PA_PS_CHK_DEL_FAIL_PUB_STR');
3577: RAISE FND_API.G_EXC_ERROR;
3578: END IF;
3579:

Line 5312: -- PA_UTILS.ADD_MESSAGE('PA',l_i_msg_data(i));

5308: --dbms_output.put_line('import proj: '||l_i_return_status);
5309: --Check for error
5310: -- IF (x_msg_count > 0) THEN
5311: -- FOR i IN 1..x_msg_count LOOP
5312: -- PA_UTILS.ADD_MESSAGE('PA',l_i_msg_data(i));
5313: -- END LOOP;
5314: -- END IF;
5315:
5316: l_msg_count := FND_MSG_PUB.count_msg;

Line 6693: PA_UTILS.ADD_MESSAGE('PA','PA_PS_WORKING_VER_EXISTS');

6689: OPEN l_check_working_versions_csr(p_structure_version_id);
6690: FETCH l_check_working_versions_csr INTO l_dummy;
6691: if l_check_working_versions_csr%FOUND then
6692: CLOSE l_check_working_versions_csr;
6693: PA_UTILS.ADD_MESSAGE('PA','PA_PS_WORKING_VER_EXISTS');
6694: x_msg_data := 'PA_PS_WORKING_VER_EXISTS';
6695: RAISE FND_API.G_EXC_ERROR;
6696: end if;
6697: CLOSE l_check_working_versions_csr;

Line 7487: PA_UTILS.ADD_MESSAGE('PA','PA_PS_STRUC_NOT_EXIST');

7483: OPEN l_get_structure_csr(p_src_project_id);
7484: FETCH l_get_structure_csr INTO l_structure_rec;
7485: if l_get_structure_csr%NOTFOUND then
7486: CLOSE l_get_structure_csr;
7487: PA_UTILS.ADD_MESSAGE('PA','PA_PS_STRUC_NOT_EXIST');
7488: l_msg_data := 'PA_PS_STRUC_NOT_EXIST';
7489: RAISE FND_API.G_EXC_ERROR;
7490: end if;
7491:

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

8571: WHERE ELEMENT_VERSION_ID = p_structure_version_id;
8572: ELSIF p_project_id IS NOT NULL THEN
8573: l_project_id := p_project_id;
8574: ELSE
8575: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
8576: p_msg_name => 'PA_INVALID_STR_VERSION_ID');
8577: RAISE FND_API.G_EXC_ERROR;
8578: END IF;
8579: /* Added below code to improve performance */

Line 9006: PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_CANNOT_SPLIT_STRUCT');

9002:
9003: --check if there is a published workplan version
9004: IF PA_PROJECT_STRUCTURE_UTILS.CHECK_PUBLISHED_VER_EXISTS(p_project_id, l_structure_id) = 'Y' THEN
9005: --cannot split if publish version exists.
9006: PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_CANNOT_SPLIT_STRUCT');
9007: x_msg_data := 'PA_PS_CANNOT_SPLIT_STRUCT';
9008: RAISE FND_API.G_EXC_ERROR;
9009: END IF;
9010:

Line 9253: -- PA_UTILS.ADD_MESSAGE('PA','PA_PS_MISS_TRANSAC_TASK');

9249:
9250: --hsiu: bug 2684465
9251: --Check if this structure missing tasks with transactions
9252: -- IF ('Y' <> PA_PROJECT_STRUCTURE_UTILS.check_miss_transaction_tasks(p_structure_version_id)) THEN
9253: -- PA_UTILS.ADD_MESSAGE('PA','PA_PS_MISS_TRANSAC_TASK');
9254: -- x_msg_data := 'PA_PS_MISS_TRANSAC_TASK';
9255: -- RAISE FND_API.G_EXC_ERROR;
9256: -- END IF;
9257: PA_PROJECT_STRUCTURE_UTILS.CHECK_MISS_TRANSACTION_TASKS(p_structure_version_id,

Line 9300: PA_UTILS.ADD_MESSAGE('PA','PA_PS_LINK_STRUC_NOT_PUB');

9296:
9297: /*
9298: --Check if this structure can be published (ie, if linked structures are published)
9299: IF ('Y' <> PA_PROJECT_STRUCTURE_UTILS.Check_Publish_Struc_Ver_Ok(p_structure_version_id)) THEN
9300: PA_UTILS.ADD_MESSAGE('PA','PA_PS_LINK_STRUC_NOT_PUB');
9301: x_msg_data := 'PA_PS_LINK_STRUC_NOT_PUB';
9302: RAISE FND_API.G_EXC_ERROR;
9303: END IF;
9304: */

Line 9322: PA_UTILS.ADD_MESSAGE('PA','PA_PS_NEED_THIRD_PT_SCH');

9318: --bug 3840509
9319: IF 'Y' = nvl(PA_PROJECT_STRUCTURE_UTILS.Get_Sch_Dirty_fl(p_project_id,
9320: p_structure_version_id), 'N') THEN
9321: --need to reschedule
9322: PA_UTILS.ADD_MESSAGE('PA','PA_PS_NEED_THIRD_PT_SCH');
9323: x_msg_data := 'PA_PS_NEED_THIRD_PT_SCH';
9324: RAISE FND_API.G_EXC_ERROR;
9325: END IF;
9326: --end bug 3840509

Line 9377: PA_UTILS.ADD_MESSAGE('PA',l_msg_data);

9373: ,x_error_message_code => l_msg_data
9374: );
9375:
9376: IF (l_return_status <> 'S') THEN
9377: PA_UTILS.ADD_MESSAGE('PA',l_msg_data);
9378: x_msg_data := l_msg_data;
9379: CLOSE sel_other_structure_ver;
9380: RAISE FND_API.G_EXC_ERROR;
9381: END IF;

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

9429: ,p_err_stage => l_err_stage
9430: ,p_err_stack => l_err_stack
9431: );
9432: IF (l_err_code <> 0) THEN
9433: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
9434: p_msg_name => 'PA_PS_CREATE_WF_FAILED');
9435: x_return_status := FND_API.G_RET_STS_ERROR;
9436: END IF;
9437: ELSE

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

9434: p_msg_name => 'PA_PS_CREATE_WF_FAILED');
9435: x_return_status := FND_API.G_RET_STS_ERROR;
9436: END IF;
9437: ELSE
9438: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
9439: p_msg_name => 'PA_PS_CREATE_WF_FAILED');
9440: x_return_status := FND_API.G_RET_STS_ERROR;
9441: END IF;
9442: END IF;

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

9534: and record_version_number = p_record_version_number
9535: for update of record_version_number NOWAIT;
9536: EXCEPTION
9537: when TIMEOUT_ON_RESOURCE then
9538: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
9539: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
9540: l_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
9541: when NO_DATA_FOUND then
9542: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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

9538: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
9539: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
9540: l_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
9541: when NO_DATA_FOUND then
9542: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
9543: p_msg_name => 'PA_XC_RECORD_CHANGED');
9544: l_msg_data := 'PA_XC_RECORD_CHANGED';
9545: when OTHERS then
9546: if SQLCODE = -54 then

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

9543: p_msg_name => 'PA_XC_RECORD_CHANGED');
9544: l_msg_data := 'PA_XC_RECORD_CHANGED';
9545: when OTHERS then
9546: if SQLCODE = -54 then
9547: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
9548: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
9549: l_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
9550: else
9551: raise;

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

9565: OPEN get_status_code(p_status_code);
9566: FETCH get_status_code INTO l_dummy ;
9567: IF (get_status_code%NOTFOUND) THEN
9568: CLOSE get_status_code;
9569: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
9570: p_msg_name => 'PA_PS_STRUC_STAT_INVAL');
9571: x_msg_data := 'PA_PS_STRUC_STAT_INVAL';
9572: RAISE FND_API.G_EXC_ERROR;
9573: END IF;

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

9614: ,p_err_stage => l_err_stage
9615: ,p_err_stack => l_err_stack
9616: );
9617: IF (l_err_code <> 0) THEN
9618: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
9619: p_msg_name => 'PA_PS_CREATE_WF_FAILED');
9620: x_return_status := FND_API.G_RET_STS_ERROR;
9621: END IF;
9622: ELSE

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

9619: p_msg_name => 'PA_PS_CREATE_WF_FAILED');
9620: x_return_status := FND_API.G_RET_STS_ERROR;
9621: END IF;
9622: ELSE
9623: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
9624: p_msg_name => 'PA_PS_CREATE_WF_FAILED');
9625: x_return_status := FND_API.G_RET_STS_ERROR;
9626:
9627: END IF;

Line 9744: -- PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA'

9740: OPEN get_wf_status;
9741: FETCH get_wf_status INTO l_wf_status;
9742: IF (get_wf_status%NOTFOUND or l_wf_status <> 'Y') THEN
9743: -- IF (l_approve_req = 'Y') THEN
9744: -- PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA'
9745: -- ,p_msg_name => 'PA_PR_CANCEL_WORKFLOW_INV');
9746: -- x_return_status := FND_API.G_RET_STS_ERROR;
9747: -- x_msg_count := FND_MSG_PUB.count_msg;
9748: -- if x_msg_count = 1 then

Line 9768: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA'

9764: CLOSE get_wf_status;
9765:
9766: ELSE
9767: IF (l_approve_req = 'Y') THEN
9768: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA'
9769: ,p_msg_name => 'PA_PR_CANCEL_WORKFLOW_INV');
9770: x_return_status := FND_API.G_RET_STS_ERROR;
9771: x_msg_count := FND_MSG_PUB.count_msg;
9772: if x_msg_count = 1 then

Line 10080: PA_UTILS.ADD_MESSAGE('PA', l_err_msg_code);

10076: PA_PROJECT_STRUCTURE_UTILS.check_enable_wp_ok(p_project_id,
10077: l_ret_stat,
10078: l_err_msg_code);
10079: IF (l_ret_stat = 'N') THEN
10080: PA_UTILS.ADD_MESSAGE('PA', l_err_msg_code);
10081: x_msg_data := l_err_msg_code;
10082: RAISE FND_API.G_EXC_ERROR;
10083: END IF;
10084: --enable WP

Line 10214: PA_UTILS.ADD_MESSAGE('PA', l_err_msg_code);

10210: PA_PROJECT_STRUCTURE_UTILS.check_disable_wp_ok(p_project_id,
10211: l_ret_stat,
10212: l_err_msg_code);
10213: IF (l_ret_stat = 'N') THEN
10214: PA_UTILS.ADD_MESSAGE('PA', l_err_msg_code);
10215: x_msg_data := l_err_msg_code;
10216: RAISE FND_API.G_EXC_ERROR;
10217: END IF;
10218: --disable WP

Line 10249: PA_UTILS.ADD_MESSAGE('PA', l_err_msg_code);

10245: l_del_struc_ver_id,
10246: l_return_status,
10247: l_err_msg_code);
10248: IF (l_return_status <> 'S') THEN
10249: PA_UTILS.ADD_MESSAGE('PA', l_err_msg_code);
10250: x_msg_data := l_err_msg_code;
10251: RAISE FND_API.G_EXC_ERROR;
10252: END IF;
10253:

Line 10269: PA_UTILS.ADD_MESSAGE('PA', l_err_msg_code);

10265: ,x_error_message_code => l_err_msg_code );
10266:
10267: IF (l_return_status <> 'S') THEN
10268: x_return_status := l_return_status;
10269: PA_UTILS.ADD_MESSAGE('PA', l_err_msg_code);
10270: l_msg_data := l_err_msg_code;
10271: CLOSE get_top_tasks;
10272: RAISE FND_API.G_EXC_ERROR;
10273: END IF;

Line 10409: PA_UTILS.ADD_MESSAGE('PA', l_err_msg_code);

10405: l_del_struc_ver_id,
10406: l_return_status,
10407: l_err_msg_code);
10408: IF (l_return_status <> 'S') THEN
10409: PA_UTILS.ADD_MESSAGE('PA', l_err_msg_code);
10410: x_msg_data := l_err_msg_code;
10411: RAISE FND_API.G_EXC_ERROR;
10412: END IF;
10413:

Line 10429: PA_UTILS.ADD_MESSAGE('PA', l_err_msg_code);

10425: ,x_error_message_code => l_err_msg_code );
10426:
10427: IF (l_return_status <> 'S') THEN
10428: x_return_status := l_return_status;
10429: PA_UTILS.ADD_MESSAGE('PA', l_err_msg_code);
10430: l_msg_data := l_err_msg_code;
10431: CLOSE get_top_tasks;
10432: RAISE FND_API.G_EXC_ERROR;
10433: END IF;

Line 10491: PA_UTILS.ADD_MESSAGE('PA', l_err_msg_code);

10487: PA_PROJECT_STRUCTURE_UTILS.check_sharing_on_ok(p_project_id,
10488: l_ret_stat,
10489: l_err_msg_code);
10490: IF (l_ret_stat = 'N') THEN
10491: PA_UTILS.ADD_MESSAGE('PA', l_err_msg_code);
10492: x_msg_data := l_err_msg_code;
10493: RAISE FND_API.G_EXC_ERROR;
10494: END IF;
10495:

Line 10519: PA_UTILS.ADD_MESSAGE('PA', l_err_msg_code);

10515: l_del_struc_ver_id,
10516: l_return_status,
10517: l_err_msg_code);
10518: IF (l_return_status <> 'S') THEN
10519: PA_UTILS.ADD_MESSAGE('PA', l_err_msg_code);
10520: x_msg_data := l_err_msg_code;
10521: RAISE FND_API.G_EXC_ERROR;
10522: END IF;
10523:

Line 10540: PA_UTILS.ADD_MESSAGE('PA', l_err_msg_code);

10536:
10537:
10538: IF (l_return_status <> 'S') THEN
10539: x_return_status := l_return_status;
10540: PA_UTILS.ADD_MESSAGE('PA', l_err_msg_code);
10541: l_msg_data := l_err_msg_code;
10542: CLOSE get_top_tasks;
10543: RAISE FND_API.G_EXC_ERROR;
10544: END IF;

Line 10724: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_FIN_TK_DATE_MISS');

10720:
10721: --hsiu: commented for performance
10722: -- IF (l_start_date IS NULL) OR (l_completion_date IS NULL) THEN
10723: -- CLOSE sel_struc_and_task_vers;
10724: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_FIN_TK_DATE_MISS');
10725: -- x_msg_data := 'PA_PS_FIN_TK_DATE_MISS';
10726: -- RAISE FND_API.G_EXC_ERROR;
10727: --hsiu: 2634029
10728: -- Default sysdate or project target dates if transaction dates

Line 10907: PA_UTILS.ADD_MESSAGE('PA','PA_PS_WP_NOT_EN_SHR_ERR');

10903:
10904: --end sharing on
10905: ELSIF (p_sharing_enabled_flag = 'Y' AND
10906: PA_PROJECT_STRUCTURE_UTILS.CHECK_WORKPLAN_ENABLED(p_project_id) = 'N') THEN
10907: PA_UTILS.ADD_MESSAGE('PA','PA_PS_WP_NOT_EN_SHR_ERR');
10908: x_msg_data := 'PA_PS_WP_NOT_EN_SHR_ERR';
10909: RAISE FND_API.G_EXC_ERROR;
10910: ELSIF (p_sharing_enabled_flag = 'N') THEN
10911: --Validation

Line 10916: PA_UTILS.ADD_MESSAGE('PA', l_err_msg_code);

10912: PA_PROJECT_STRUCTURE_UTILS.check_sharing_off_ok(p_project_id,
10913: l_ret_stat,
10914: l_err_msg_code);
10915: IF (l_ret_stat = 'N') THEN
10916: PA_UTILS.ADD_MESSAGE('PA', l_err_msg_code);
10917: x_msg_data := l_err_msg_code;
10918: RAISE FND_API.G_EXC_ERROR;
10919: END IF;
10920: --sharing off

Line 10941: PA_UTILS.ADD_MESSAGE('PA', l_err_msg_code);

10937: l_del_struc_ver_id,
10938: l_return_status,
10939: l_err_msg_code);
10940: IF (l_return_status <> 'S') THEN
10941: PA_UTILS.ADD_MESSAGE('PA', l_err_msg_code);
10942: x_msg_data := l_err_msg_code;
10943: RAISE FND_API.G_EXC_ERROR;
10944: END IF;
10945:

Line 10961: PA_UTILS.ADD_MESSAGE('PA', l_err_msg_code);

10957: ,x_error_message_code => l_err_msg_code );
10958:
10959: IF (l_return_status <> 'S') THEN
10960: x_return_status := l_return_status;
10961: PA_UTILS.ADD_MESSAGE('PA', l_err_msg_code);
10962: l_msg_data := l_err_msg_code;
10963: CLOSE get_top_tasks;
10964: RAISE FND_API.G_EXC_ERROR;
10965: END IF;

Line 11430: PA_UTILS.ADD_MESSAGE('PA', l_err_msg_code);

11426: p_proj_element_id
11427: ,l_ret_stat
11428: ,l_err_msg_code);
11429: IF (l_ret_stat = 'N') THEN
11430: PA_UTILS.ADD_MESSAGE('PA', l_err_msg_code);
11431: x_msg_data := l_err_msg_code;
11432: RAISE FND_API.G_EXC_ERROR;
11433: END IF;
11434: --enable versioning

Line 11526: PA_UTILS.ADD_MESSAGE('PA', l_err_msg_code);

11522: p_proj_element_id
11523: ,l_ret_stat
11524: ,l_err_msg_code);
11525: IF (l_ret_stat = 'N') THEN
11526: PA_UTILS.ADD_MESSAGE('PA', l_err_msg_code);
11527: x_msg_data := l_err_msg_code;
11528: RAISE FND_API.G_EXC_ERROR;
11529: END IF;
11530: --disable versioning

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

13003: ,p_err_stage => l_err_stage
13004: ,p_err_stack => l_err_stack
13005: );
13006: IF (l_err_code <> 0) THEN
13007: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
13008: p_msg_name => 'PA_PS_CREATE_WF_FAILED');
13009: RAISE FND_API.G_EXC_ERROR;
13010: END IF;
13011: ELSE

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

13008: p_msg_name => 'PA_PS_CREATE_WF_FAILED');
13009: RAISE FND_API.G_EXC_ERROR;
13010: END IF;
13011: ELSE
13012: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
13013: p_msg_name => 'PA_PS_CREATE_WF_FAILED');
13014: RAISE FND_API.G_EXC_ERROR;
13015: END IF;
13016:

Line 13616: PA_UTILS.ADD_MESSAGE('PA','PA_PS_WORKING_VER_EXISTS');

13612: OPEN l_check_working_versions_csr(p_structure_version_id);
13613: FETCH l_check_working_versions_csr INTO l_dummy;
13614: if l_check_working_versions_csr%FOUND then
13615: CLOSE l_check_working_versions_csr;
13616: PA_UTILS.ADD_MESSAGE('PA','PA_PS_WORKING_VER_EXISTS');
13617: x_msg_data := 'PA_PS_WORKING_VER_EXISTS';
13618: RAISE FND_API.G_EXC_ERROR;
13619: end if;
13620: CLOSE l_check_working_versions_csr;

Line 14569: PA_UTILS.ADD_MESSAGE('PA', 'PA_WP_PROG_CANT_CHG_STR');

14565: or ((l_share_code in ('SPLIT_MAPPING','SPLIT_NO_MAPPING'))
14566: and (p_sharing_option_code IN ('SHARE_FULL','SHARE_PARTIAL'))))
14567: ) then
14568:
14569: PA_UTILS.ADD_MESSAGE('PA', 'PA_WP_PROG_CANT_CHG_STR');
14570:
14571: RAISE FND_API.G_EXC_ERROR;
14572:
14573: end if;

Line 14585: PA_UTILS.ADD_MESSAGE('PA', l_err_msg_code);

14581: PA_PROJECT_STRUCTURE_UTILS.check_enable_wp_ok(p_project_id,
14582: l_ret_stat,
14583: l_err_msg_code);
14584: IF (l_ret_stat = 'N') THEN
14585: PA_UTILS.ADD_MESSAGE('PA', l_err_msg_code);
14586: x_msg_data := l_err_msg_code;
14587: RAISE FND_API.G_EXC_ERROR;
14588: END IF;
14589: END IF;

Line 14597: PA_UTILS.ADD_MESSAGE('PA', l_err_msg_code);

14593: PA_PROJECT_STRUCTURE_UTILS.check_disable_wp_ok(p_project_id,
14594: l_ret_stat,
14595: l_err_msg_code);
14596: IF (l_ret_stat = 'N') THEN
14597: PA_UTILS.ADD_MESSAGE('PA', l_err_msg_code);
14598: x_msg_data := l_err_msg_code;
14599: RAISE FND_API.G_EXC_ERROR;
14600: END IF;
14601: END IF;

Line 14609: PA_UTILS.ADD_MESSAGE('PA', l_err_msg_code);

14605: PA_PROJECT_STRUCTURE_UTILS.check_sharing_on_ok(p_project_id,
14606: l_ret_stat,
14607: l_err_msg_code);
14608: IF (l_ret_stat = 'N') THEN
14609: PA_UTILS.ADD_MESSAGE('PA', l_err_msg_code);
14610: x_msg_data := l_err_msg_code;
14611: RAISE FND_API.G_EXC_ERROR;
14612: END IF;
14613: END IF;

Line 14621: PA_UTILS.ADD_MESSAGE('PA', l_err_msg_code);

14617: PA_PROJECT_STRUCTURE_UTILS.check_sharing_off_ok(p_project_id,
14618: l_ret_stat,
14619: l_err_msg_code);
14620: IF (l_ret_stat = 'N') THEN
14621: PA_UTILS.ADD_MESSAGE('PA', l_err_msg_code);
14622: x_msg_data := l_err_msg_code;
14623: RAISE FND_API.G_EXC_ERROR;
14624: END IF;
14625: END IF;

Line 15772: PA_UTILS.ADD_MESSAGE('PA', l_err_msg_code);

15768: l_del_struc_ver_id,
15769: l_return_status,
15770: l_err_msg_code);
15771: IF (l_return_status <> 'S') THEN
15772: PA_UTILS.ADD_MESSAGE('PA', l_err_msg_code);
15773: x_msg_data := l_err_msg_code;
15774: RAISE FND_API.G_EXC_ERROR;
15775: END IF;
15776:

Line 15792: PA_UTILS.ADD_MESSAGE('PA', l_err_msg_code);

15788: ,x_error_message_code => l_err_msg_code );
15789:
15790: IF (l_return_status <> 'S') THEN
15791: x_return_status := l_return_status;
15792: PA_UTILS.ADD_MESSAGE('PA', l_err_msg_code);
15793: l_msg_data := l_err_msg_code;
15794: CLOSE get_top_tasks;
15795: RAISE FND_API.G_EXC_ERROR;
15796: END IF;

Line 16261: PA_UTILS.ADD_MESSAGE('PA', l_err_msg_code);

16257: ,x_msg_data => l_msg_data
16258: );
16259:
16260: IF (l_return_status <> 'S') THEN
16261: PA_UTILS.ADD_MESSAGE('PA', l_err_msg_code);
16262: x_msg_data := l_err_msg_code;
16263: RAISE FND_API.G_EXC_ERROR;
16264: END IF;
16265:

Line 16349: PA_UTILS.ADD_MESSAGE('PA', l_err_msg_code);

16345: l_del_struc_ver_id,
16346: l_return_status,
16347: l_err_msg_code);
16348: IF (l_return_status <> 'S') THEN
16349: PA_UTILS.ADD_MESSAGE('PA', l_err_msg_code);
16350: x_msg_data := l_err_msg_code;
16351: RAISE FND_API.G_EXC_ERROR;
16352: END IF;
16353:

Line 16369: PA_UTILS.ADD_MESSAGE('PA', l_err_msg_code);

16365: ,x_error_message_code => l_err_msg_code );
16366:
16367: IF (l_return_status <> 'S') THEN
16368: x_return_status := l_return_status;
16369: PA_UTILS.ADD_MESSAGE('PA', l_err_msg_code);
16370: l_msg_data := l_err_msg_code;
16371: CLOSE get_top_tasks;
16372: RAISE FND_API.G_EXC_ERROR;
16373: END IF;

Line 16788: PA_UTILS.ADD_MESSAGE('PA', l_err_msg_code);

16784: ,x_msg_data => l_msg_data
16785: );
16786:
16787: IF (l_return_status <> 'S') THEN
16788: PA_UTILS.ADD_MESSAGE('PA', l_err_msg_code);
16789: x_msg_data := l_err_msg_code;
16790: RAISE FND_API.G_EXC_ERROR;
16791: END IF;
16792:

Line 16884: PA_UTILS.ADD_MESSAGE('PA', l_err_msg_code);

16880: l_del_struc_ver_id,
16881: l_return_status,
16882: l_err_msg_code);
16883: IF (l_return_status <> 'S') THEN
16884: PA_UTILS.ADD_MESSAGE('PA', l_err_msg_code);
16885: x_msg_data := l_err_msg_code;
16886: RAISE FND_API.G_EXC_ERROR;
16887: END IF;
16888:

Line 16904: PA_UTILS.ADD_MESSAGE('PA', l_err_msg_code);

16900: ,x_error_message_code => l_err_msg_code );
16901:
16902: IF (l_return_status <> 'S') THEN
16903: x_return_status := l_return_status;
16904: PA_UTILS.ADD_MESSAGE('PA', l_err_msg_code);
16905: l_msg_data := l_err_msg_code;
16906: CLOSE get_top_tasks;
16907: RAISE FND_API.G_EXC_ERROR;
16908: END IF;

Line 17219: PA_UTILS.ADD_MESSAGE('PA', l_err_msg_code);

17215: l_del_struc_ver_id,
17216: l_return_status,
17217: l_err_msg_code);
17218: IF (l_return_status <> 'S') THEN
17219: PA_UTILS.ADD_MESSAGE('PA', l_err_msg_code);
17220: x_msg_data := l_err_msg_code;
17221: RAISE FND_API.G_EXC_ERROR;
17222: END IF;
17223:

Line 17239: PA_UTILS.ADD_MESSAGE('PA', l_err_msg_code);

17235: ,x_error_message_code => l_err_msg_code );
17236:
17237: IF (l_return_status <> 'S') THEN
17238: x_return_status := l_return_status;
17239: PA_UTILS.ADD_MESSAGE('PA', l_err_msg_code);
17240: l_msg_data := l_err_msg_code;
17241: CLOSE get_top_tasks;
17242: RAISE FND_API.G_EXC_ERROR;
17243: END IF;

Line 17313: PA_UTILS.ADD_MESSAGE('PA', l_err_msg_code);

17309: l_del_struc_ver_id,
17310: l_return_status,
17311: l_err_msg_code);
17312: IF (l_return_status <> 'S') THEN
17313: PA_UTILS.ADD_MESSAGE('PA', l_err_msg_code);
17314: x_msg_data := l_err_msg_code;
17315: RAISE FND_API.G_EXC_ERROR;
17316: END IF;
17317:

Line 17334: PA_UTILS.ADD_MESSAGE('PA', l_err_msg_code);

17330:
17331:
17332: IF (l_return_status <> 'S') THEN
17333: x_return_status := l_return_status;
17334: PA_UTILS.ADD_MESSAGE('PA', l_err_msg_code);
17335: l_msg_data := l_err_msg_code;
17336: CLOSE get_top_tasks;
17337: RAISE FND_API.G_EXC_ERROR;
17338: END IF;

Line 17613: PA_UTILS.ADD_MESSAGE('PA', l_err_msg_code);

17609: l_del_struc_ver_id,
17610: l_return_status,
17611: l_err_msg_code);
17612: IF (l_return_status <> 'S') THEN
17613: PA_UTILS.ADD_MESSAGE('PA', l_err_msg_code);
17614: x_msg_data := l_err_msg_code;
17615: RAISE FND_API.G_EXC_ERROR;
17616: END IF;
17617:

Line 17633: PA_UTILS.ADD_MESSAGE('PA', l_err_msg_code);

17629: ,x_error_message_code => l_err_msg_code );
17630:
17631: IF (l_return_status <> 'S') THEN
17632: x_return_status := l_return_status;
17633: PA_UTILS.ADD_MESSAGE('PA', l_err_msg_code);
17634: l_msg_data := l_err_msg_code;
17635: CLOSE get_top_tasks;
17636: RAISE FND_API.G_EXC_ERROR;
17637: END IF;

Line 17705: PA_UTILS.ADD_MESSAGE('PA', l_err_msg_code);

17701: l_del_struc_ver_id,
17702: l_return_status,
17703: l_err_msg_code);
17704: IF (l_return_status <> 'S') THEN
17705: PA_UTILS.ADD_MESSAGE('PA', l_err_msg_code);
17706: x_msg_data := l_err_msg_code;
17707: RAISE FND_API.G_EXC_ERROR;
17708: END IF;
17709:

Line 17726: PA_UTILS.ADD_MESSAGE('PA', l_err_msg_code);

17722:
17723:
17724: IF (l_return_status <> 'S') THEN
17725: x_return_status := l_return_status;
17726: PA_UTILS.ADD_MESSAGE('PA', l_err_msg_code);
17727: l_msg_data := l_err_msg_code;
17728: CLOSE get_top_tasks;
17729: RAISE FND_API.G_EXC_ERROR;
17730: END IF;

Line 18119: Pa_Utils.ADD_MESSAGE

18115:
18116: --bug 4275096
18117: IF l_sys_program_flag = 'N' AND l_allow_multi_program_rollup = 'Y'
18118: THEN
18119: Pa_Utils.ADD_MESSAGE
18120: ( p_app_short_name => 'PA',
18121: p_msg_name =>'PA_PS_EN_SYS_PROG_ERR');
18122: RAISE FND_API.G_EXC_ERROR;
18123: END IF;

Line 18129: Pa_Utils.ADD_MESSAGE

18125:
18126: IF (l_proj_sys_program_flag='Y' and nvl(l_sys_program_flag,'N')='N' ) then
18127: l_flag := PA_RELATIONSHIP_UTILS.DISABLE_SYS_PROG_OK(p_project_id);
18128: If l_flag='N' Then
18129: Pa_Utils.ADD_MESSAGE
18130: ( p_app_short_name => 'PA',
18131: p_msg_name =>'PA_PS_DIS_SYS_PROG_ERR');
18132: RAISE FND_API.G_EXC_ERROR;
18133: END IF;

Line 18139: Pa_Utils.ADD_MESSAGE

18135:
18136: IF (l_proj_allow_program_rollup='Y' and nvl(l_allow_multi_program_rollup,'N')='N' ) then
18137: l_flag := PA_RELATIONSHIP_UTILS.DISABLE_MULTI_PROG_OK(p_project_id);
18138: IF l_flag ='N' Then
18139: Pa_Utils.ADD_MESSAGE
18140: ( p_app_short_name => 'PA',
18141: p_msg_name =>'PA_PS_DIS_MULTI_PROG_ERR');
18142: RAISE FND_API.G_EXC_ERROR;
18143: END IF;