DBA Data[Home] [Help]

APPS.PA_PROGRESS_REPORT_PVT dependencies on PA_UTILS

Line 104: PA_UTILS.Add_Message( p_app_short_name => 'PA'

100: CLOSE get_report_status;
101:
102: IF l_status <> 'PROGRESS_REPORT_WORKING' THEN
103:
104: PA_UTILS.Add_Message( p_app_short_name => 'PA'
105: ,p_msg_name => 'PA_PR_STATUS_NOT_WORKING');
106: x_return_status := FND_API.G_RET_STS_ERROR;
107:
108: ELSE

Line 111: PA_UTILS.Add_Message( p_app_short_name => 'PA'

107:
108: ELSE
109:
110: IF (p_region_code IS NULL) then
111: PA_UTILS.Add_Message( p_app_short_name => 'PA'
112: ,p_msg_name => 'PA_REGION_CODE_INV');
113: x_return_status := FND_API.G_RET_STS_ERROR;
114: END IF;
115:

Line 130: PA_UTILS.Add_Message( p_app_short_name => 'PA'

126:
127: -- check if exists in pa_object_page_versions
128:
129: IF (p_version_id IS NULL) THEN
130: PA_UTILS.Add_Message( p_app_short_name => 'PA'
131: ,p_msg_name => 'PA_PR_VERSION_ID_INV'
132: , p_token1 => 'TEMPLATE_TYPE'
133: , p_value1 => l_type);
134: x_return_status := FND_API.G_RET_STS_ERROR;

Line 350: PA_UTILS.Add_Message( p_app_short_name => 'PA'

346: CLOSE get_template_type;
347:
348: -- check mandatory version_id
349: IF (p_version_id IS NULL) then
350: PA_UTILS.Add_Message( p_app_short_name => 'PA'
351: ,p_msg_name => 'PA_PR_VERSION_ID_INV'
352: , p_token1 => 'TEMPLATE_TYPE'
353: , p_value1 => l_type);
354: x_return_status := FND_API.G_RET_STS_ERROR;

Line 359: PA_UTILS.Add_Message( p_app_short_name => 'PA'

355: END IF;
356: --Check mandatory region source type
357: IF (p_region_source_type IS NULL OR
358: p_region_source_type NOT IN ('STD','DFF', 'STD_CUST')) then
359: PA_UTILS.Add_Message( p_app_short_name => 'PA'
360: ,p_msg_name => 'PA_PR_REGION_SRC_INV'
361: , p_token1 => 'TEMPLATE_TYPE'
362: , p_value1 => l_type);
363: x_return_status := FND_API.G_RET_STS_ERROR;

Line 368: PA_UTILS.Add_Message( p_app_short_name => 'PA'

364: END IF;
365:
366: -- check mandatory region_code
367: IF (p_region_code IS NULL) then
368: PA_UTILS.Add_Message( p_app_short_name => 'PA'
369: ,p_msg_name => 'PA_REGION_CODE_INV');
370: x_return_status := FND_API.G_RET_STS_ERROR;
371: END IF;
372:

Line 375: PA_UTILS.Add_Message( p_app_short_name => 'PA'

371: END IF;
372:
373: -- check mandatory record_sequence
374: IF (p_record_sequence IS NULL) then
375: PA_UTILS.Add_Message( p_app_short_name => 'PA'
376: ,p_msg_name => 'PA_PR_RECORD_SEQUENCE_INV'
377: , p_token1 => 'TEMPLATE_TYPE'
378: , p_value1 => l_type);
379: x_return_status := FND_API.G_RET_STS_ERROR;

Line 394: PA_UTILS.Add_Message( p_app_short_name => 'PA'

390: CLOSE get_report_status;
391:
392: IF l_status <> 'PROGRESS_REPORT_WORKING' THEN
393:
394: PA_UTILS.Add_Message( p_app_short_name => 'PA'
395: ,p_msg_name => 'PA_PR_STATUS_NOT_WORKING');
396: x_return_status := FND_API.G_RET_STS_ERROR;
397: RETURN;
398:

Line 408: PA_UTILS.Add_Message( p_app_short_name => 'PA'

404: FETCH check_record_version INTO l_rowid;
405:
406: IF check_record_version%NOTFOUND THEN
407:
408: PA_UTILS.Add_Message( p_app_short_name => 'PA'
409: ,p_msg_name => 'PA_PR_RECORD_CHANGED');
410:
411: x_return_status := FND_API.G_RET_STS_ERROR;
412:

Line 617: PA_UTILS.Add_Message( p_app_short_name => 'PA'

613: CLOSE get_template_type;
614:
615: -- check mandatory version_id
616: IF (p_version_id IS NULL) then
617: PA_UTILS.Add_Message( p_app_short_name => 'PA'
618: ,p_msg_name => 'PA_PR_VERSION_ID_INV'
619: , p_token1 => 'TEMPLATE_TYPE'
620: , p_value1 => l_type);
621: x_return_status := FND_API.G_RET_STS_ERROR;

Line 627: PA_UTILS.Add_Message( p_app_short_name => 'PA'

623:
624: --Check mandatory region source type
625: IF (p_region_source_type IS NULL OR
626: p_region_source_type NOT IN ('STD','DFF', 'STD_CUST')) then
627: PA_UTILS.Add_Message( p_app_short_name => 'PA'
628: ,p_msg_name => 'PA_PR_REGION_SRC_INV'
629: , p_token1 => 'TEMPLATE_TYPE'
630: , p_value1 => l_type);
631: x_return_status := FND_API.G_RET_STS_ERROR;

Line 636: PA_UTILS.Add_Message( p_app_short_name => 'PA'

632: END IF;
633:
634: -- check mandatory region_code
635: IF (p_region_code IS NULL) then
636: PA_UTILS.Add_Message( p_app_short_name => 'PA'
637: ,p_msg_name => 'PA_REGION_CODE_INV');
638: x_return_status := FND_API.G_RET_STS_ERROR;
639: END IF;
640:

Line 650: PA_UTILS.Add_Message( p_app_short_name => 'PA'

646: CLOSE get_report_status;
647:
648: IF l_status <> 'PROGRESS_REPORT_WORKING' THEN
649:
650: PA_UTILS.Add_Message( p_app_short_name => 'PA'
651: ,p_msg_name => 'PA_PR_STATUS_NOT_WORKING');
652: x_return_status := FND_API.G_RET_STS_ERROR;
653: RETURN;
654:

Line 660: PA_UTILS.Add_Message( p_app_short_name => 'PA'

656:
657:
658: -- check mandatory record_sequence
659: /* IF (p_record_sequence IS NULL) then
660: PA_UTILS.Add_Message( p_app_short_name => 'PA'
661: ,p_msg_name => 'PA_PR_RECORD_SEQUENCE_INV'
662: , p_token1 => 'TEMPLATE_TYPE'
663: , p_value1 => l_type);
664: x_return_status := FND_API.G_RET_STS_ERROR;

Line 812: PA_UTILS.Add_Message( p_app_short_name => 'PA'

808: CLOSE get_template_type;
809:
810: -- check mandatory version_id
811: IF (p_version_id IS NULL) then
812: PA_UTILS.Add_Message( p_app_short_name => 'PA'
813: ,p_msg_name => 'PA_PR_VERSION_ID_INV'
814: , p_token1 => 'TEMPLATE_TYPE'
815: , p_value1 => l_type);
816: x_return_status := FND_API.G_RET_STS_ERROR;

Line 826: PA_UTILS.Add_Message( p_app_short_name => 'PA'

822: OPEN check_status_published;
823: FETCH check_status_published INTO l_rowid;
824:
825: IF check_status_published%NOTFOUND THEN
826: PA_UTILS.Add_Message( p_app_short_name => 'PA'
827: ,p_msg_name => 'PA_OBSOLETE_REPORT_INV');
828:
829: x_return_status := FND_API.G_RET_STS_ERROR;
830:

Line 1002: PA_UTILS.Add_Message( p_app_short_name => 'PA'

998: CLOSE get_template_type;
999:
1000: -- check mandatory version_id
1001: IF (p_version_id IS NULL) then
1002: PA_UTILS.Add_Message( p_app_short_name => 'PA'
1003: ,p_msg_name => 'PA_PR_VERSION_ID_INV'
1004: , p_token1 => 'TEMPLATE_TYPE'
1005: , p_value1 => l_type);
1006: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1016: PA_UTILS.Add_Message( p_app_short_name => 'PA'

1012: OPEN check_status_submitted;
1013: FETCH check_status_submitted INTO l_rowid;
1014:
1015: IF check_status_submitted%NOTFOUND THEN
1016: PA_UTILS.Add_Message( p_app_short_name => 'PA'
1017: ,p_msg_name => 'PA_PR_RECORD_CHANGED');
1018:
1019: x_return_status := FND_API.G_RET_STS_ERROR;
1020:

Line 1152: PA_UTILS.Add_Message( p_app_short_name => 'PA'

1148: CLOSE get_template_type;
1149:
1150: -- check mandatory version_id
1151: IF (p_version_id IS NULL) then
1152: PA_UTILS.Add_Message( p_app_short_name => 'PA'
1153: ,p_msg_name => 'PA_PR_VERSION_ID_INV'
1154: , p_token1 => 'TEMPLATE_TYPE'
1155: , p_value1 => l_type);
1156: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1166: PA_UTILS.Add_Message( p_app_short_name => 'PA'

1162: OPEN check_status_submitted;
1163: FETCH check_status_submitted INTO l_rowid;
1164:
1165: IF check_status_submitted%NOTFOUND THEN
1166: PA_UTILS.Add_Message( p_app_short_name => 'PA'
1167: ,p_msg_name => 'PA_PR_RECORD_CHANGED');
1168:
1169: x_return_status := FND_API.G_RET_STS_ERROR;
1170:

Line 1319: PA_UTILS.Add_Message( p_app_short_name => 'PA'

1315: CLOSE get_template_type;
1316:
1317: -- check mandatory version_id
1318: IF (p_version_id IS NULL) then
1319: PA_UTILS.Add_Message( p_app_short_name => 'PA'
1320: ,p_msg_name => 'PA_PR_VERSION_ID_INV'
1321: , p_token1 => 'TEMPLATE_TYPE'
1322: , p_value1 => l_type);
1323: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1329: PA_UTILS.Add_Message( p_app_short_name => 'PA'

1325:
1326: --debug_msg ('before update 1' );
1327:
1328: IF (Trunc(p_report_end_date) < Trunc(p_report_start_date)) THEN
1329: PA_UTILS.Add_Message( p_app_short_name => 'PA'
1330: ,p_msg_name => 'PA_REPORT_END_DATE_INV');
1331: x_return_status := FND_API.G_RET_STS_ERROR;
1332: END IF;
1333:

Line 1348: PA_UTILS.Add_Message( p_app_short_name => 'PA'

1344: OPEN get_person_id;
1345: FETCH get_person_id INTO l_reported_by;
1346:
1347: IF (get_person_id%notfound) THEN
1348: PA_UTILS.Add_Message( p_app_short_name => 'PA'
1349: ,p_msg_name => 'PA_PR_REPORTED_BY_INV');
1350: x_return_status := FND_API.G_RET_STS_ERROR;
1351: END IF;
1352: CLOSE get_person_id;

Line 1365: PA_UTILS.Add_Message( p_app_short_name => 'PA'

1361: FETCH is_report_status_working INTO l_ret;
1362: CLOSE is_report_status_working;
1363:
1364: IF l_ret <> 'Y' THEN
1365: PA_UTILS.Add_Message( p_app_short_name => 'PA'
1366: ,p_msg_name => 'PA_UPDATE_REPORT_INV');
1367: x_return_status := FND_API.G_RET_STS_ERROR;
1368: END IF;
1369:

Line 1562: PA_UTILS.Add_Message( p_app_short_name => 'PA'

1558:
1559: IF (p_page_type_code = 'PPR') THEN
1560: IF pa_progress_report_utils.is_delete_page_layout_ok(p_page_type_code, p_object_type, p_object_id, p_report_Type_id ) <> 'Y' THEN
1561: -- we have to quit,
1562: PA_UTILS.Add_Message( p_app_short_name => 'PA'
1563: ,p_msg_name => 'PA_REPORT_TYPE_REMOVE_INV');
1564: x_return_status := FND_API.G_RET_STS_ERROR;
1565: RETURN;
1566:

Line 1610: PA_UTILS.Add_Message( p_app_short_name => 'PA'

1606: FETCH get_page_id INTO l_page_id;
1607:
1608:
1609: IF (get_page_id%notfound ) THEN
1610: PA_UTILS.Add_Message( p_app_short_name => 'PA'
1611: ,p_msg_name => 'PA_PAGE_LAYOUT_NAME_INV');
1612: x_return_status := FND_API.G_RET_STS_ERROR;
1613: RETURN;
1614:

Line 1628: --PA_UTILS.Add_Message( p_app_short_name => 'PA'

1624: --Bug#3302984 Commented Else.
1625: --ELSE
1626: -- l_page_id := p_page_id;
1627:
1628: --PA_UTILS.Add_Message( p_app_short_name => 'PA'
1629: -- ,p_msg_name => 'PA_PAGE_ID_INV');
1630: --x_return_status := FND_API.G_RET_STS_ERROR;
1631: END IF;
1632:

Line 1648: PA_UTILS.Add_Message( p_app_short_name => 'PA'

1644: FETCH check_object_page_layout_exits INTO page_id_l, approval_required_l;
1645: close check_object_page_layout_exits;
1646: if (page_id_l <> l_page_id or approval_required_l <> p_approval_required) then
1647: -- we have to quit,
1648: PA_UTILS.Add_Message( p_app_short_name => 'PA'
1649: ,p_msg_name => 'PA_REPORT_TYPE_EDIT_INV');
1650: x_return_status := FND_API.G_RET_STS_ERROR;
1651: RETURN;
1652: end if;

Line 1658: PA_UTILS.Add_Message( p_app_short_name => 'PA'

1654: END IF;
1655:
1656: If (p_effective_to is not null and p_effective_from is null) or
1657: (p_effective_to < p_effective_from) THEN
1658: PA_UTILS.Add_Message( p_app_short_name => 'PA'
1659: ,p_msg_name => 'PA_EFFECTIVE_ED_DATE_INV');
1660: x_return_status := 'E';
1661: End If;
1662:

Line 1670: PA_UTILS.Add_Message( p_app_short_name => 'PA'

1666: INTO l_approver_source_id, l_approver_source_type
1667: FROM pa_people_lov_v
1668: WHERE name = p_approver_source_name;
1669: exception when TOO_MANY_ROWS then
1670: PA_UTILS.Add_Message( p_app_short_name => 'PA'
1671: ,p_msg_name => 'PA_APPR_SOURCE_NAME_MULTIPLE');
1672: x_return_status := 'E';
1673: when OTHERS then
1674: PA_UTILS.Add_Message( p_app_short_name => 'PA'

Line 1674: PA_UTILS.Add_Message( p_app_short_name => 'PA'

1670: PA_UTILS.Add_Message( p_app_short_name => 'PA'
1671: ,p_msg_name => 'PA_APPR_SOURCE_NAME_MULTIPLE');
1672: x_return_status := 'E';
1673: when OTHERS then
1674: PA_UTILS.Add_Message( p_app_short_name => 'PA'
1675: ,p_msg_name => 'PA_APPR_SOURCE_NAME_INV');
1676: x_return_status := 'E';
1677: end;
1678:

Line 1690: PA_UTILS.Add_Message( p_app_short_name => 'PA'

1686: and the user has not entered any approver name */
1687:
1688: /* Bug No. 2636791 -- commented this */
1689: /* If (l_approver_source_id is not null and p_approval_required = 'N') then
1690: PA_UTILS.Add_Message( p_app_short_name => 'PA'
1691: ,p_msg_name => 'PA_PS_APPROVER_ERR');
1692: x_return_status := 'E';
1693: End If; */
1694:

Line 1697: PA_UTILS.Add_Message( p_app_short_name => 'PA'

1693: End If; */
1694:
1695: /* Bug 2753246 no need for this check as HR manager is the default approver)
1696: If (l_approver_source_id is null and p_approval_required <> 'N') then
1697: PA_UTILS.Add_Message( p_app_short_name => 'PA'
1698: ,p_msg_name => 'PA_APPR_SOURCE_NAME_INV');
1699: x_return_status := 'E';
1700: End If; */
1701:

Line 1739: PA_UTILS.Add_Message( p_app_short_name => 'PA'

1735: IF (p_page_type_code = 'PPR') THEN
1736: OPEN report_type_exists;
1737: FETCH report_type_exists INTO l_rowid;
1738: IF report_type_exists%NOTFOUND THEN
1739: PA_UTILS.Add_Message( p_app_short_name => 'PA'
1740: ,p_msg_name => 'PA_PS_REPORT_TYPE_INVALID');
1741: x_return_status := FND_API.G_RET_STS_ERROR;
1742: RETURN;
1743: ELSE

Line 2036: PA_UTILS.Add_Message( p_app_short_name => 'PA'

2032: CLOSE get_template_type;
2033:
2034: -- check mandatory version_id
2035: IF (p_version_id IS NULL) then
2036: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2037: ,p_msg_name => 'PA_PR_VERSION_ID_INV'
2038: , p_token1 => 'TEMPLATE_TYPE'
2039: , p_value1 => l_type);
2040: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2094: -- PA_UTILS.Add_Message( p_app_short_name => 'PA'

2090:
2091: -- if workflow is required, we are canceling the submission
2092: -- failed, return error.
2093: -- IF (l_dummy = 'Y' or l_dummy = 'A' )THEN
2094: -- PA_UTILS.Add_Message( p_app_short_name => 'PA'
2095: -- ,p_msg_name => 'PA_PR_CANCEL_WORKFLOW_INV');
2096: -- x_return_status := FND_API.G_RET_STS_ERROR;
2097: NULL;
2098: END IF;

Line 2253: PA_UTILS.Add_Message( p_app_short_name => 'PA'

2249: CLOSE get_template_type;
2250:
2251: -- check mandatory version_id
2252: IF (p_version_id IS NULL) then
2253: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2254: ,p_msg_name => 'PA_PR_VERSION_ID_INV'
2255: , p_token1 => 'TEMPLATE_TYPE'
2256: , p_value1 => l_type);
2257: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2336: PA_UTILS.Add_Message( p_app_short_name => 'PA'

2332:
2333: IF (get_wf_status%notfound or
2334: l_wf_status <> 'Y' ) THEN
2335: IF (l_dummy = 'Y' or l_dummy = 'A') then
2336: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2337: ,p_msg_name => 'PA_PR_CANCEL_WORKFLOW_INV');
2338: --todo
2339: -- x_return_status := FND_API.G_RET_STS_ERROR;
2340: END IF;

Line 2368: PA_UTILS.Add_Message( p_app_short_name => 'PA'

2364:
2365: -- if workflow is required, we are canceling the submission
2366: -- failed, return error.
2367: IF (l_dummy = 'Y' or l_dummy = 'A' )THEN
2368: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2369: ,p_msg_name => 'PA_PR_CANCEL_WORKFLOW_INV');
2370: x_return_status := FND_API.G_RET_STS_ERROR;
2371:
2372: END IF;

Line 2506: PA_UTILS.Add_Message( p_app_short_name => 'PA'

2502:
2503:
2504: -- check mandatory version_id
2505: IF (p_version_id IS NULL) then
2506: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2507: ,p_msg_name => 'PA_PR_VERSION_ID_INV'
2508: , p_token1 => 'TEMPLATE_TYPE'
2509: , p_value1 => l_type);
2510: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2767: PA_UTILS.Add_Message( p_app_short_name => 'PA'

2763: CLOSE get_template_type;
2764:
2765: -- check mandatory version_id
2766: IF (p_version_id IS NULL) then
2767: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2768: ,p_msg_name => 'PA_PR_VERSION_ID_INV'
2769: , p_token1 => 'TEMPLATE_TYPE'
2770: , p_value1 => l_type);
2771:

Line 2780: PA_UTILS.Add_Message( p_app_short_name => 'PA'

2776:
2777: FETCH get_object_id INTO l_project_id;
2778:
2779: IF get_object_id%notfound THEN
2780: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2781: ,p_msg_name => 'PA_PR_STATUS_NOT_WORKING');
2782: x_return_status := FND_API.G_RET_STS_ERROR;
2783: END IF;
2784:

Line 2870: PA_UTILS.Add_Message( p_app_short_name => 'PA'

2866: ,p_err_stack => l_err_stack
2867: );
2868:
2869: IF l_err_code <> 0 THEN
2870: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2871: ,p_msg_name => 'PA_PR_CREATE_WF_FAILED');
2872: x_return_status := FND_API.G_RET_STS_ERROR;
2873:
2874: END IF;

Line 2878: PA_UTILS.Add_Message( p_app_short_name => 'PA'

2874: END IF;
2875:
2876:
2877: ELSE
2878: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2879: ,p_msg_name => 'PA_PR_CREATE_WF_FAILED');
2880: x_return_status := FND_API.G_RET_STS_ERROR;
2881:
2882: END IF;

Line 2994: -- PA_UTILS.Add_Message( p_app_short_name => 'PA'

2990:
2991: FETCH get_object_id INTO l_project_id,l_report_end_date, l_report_type_id;
2992:
2993: -- IF get_object_id%notfound THEN
2994: -- PA_UTILS.Add_Message( p_app_short_name => 'PA'
2995: -- ,p_msg_name => 'PA_PR_STATUS_NOT_WORKING');
2996: --x_return_status := FND_API.G_RET_STS_ERROR;
2997: --END IF;
2998: CLOSE get_object_id;

Line 3135: PA_UTILS.Add_Message( p_app_short_name => 'PA'

3131: ,p_err_stack => l_err_stack
3132: );
3133:
3134: IF l_err_code <> 0 THEN
3135: PA_UTILS.Add_Message( p_app_short_name => 'PA'
3136: ,p_msg_name => 'PA_PR_CREATE_WF_FAILED');
3137: x_return_status := FND_API.G_RET_STS_ERROR;
3138:
3139: END IF;

Line 3143: PA_UTILS.Add_Message( p_app_short_name => 'PA'

3139: END IF;
3140:
3141:
3142: ELSE
3143: PA_UTILS.Add_Message( p_app_short_name => 'PA'
3144: ,p_msg_name => 'PA_PR_CREATE_WF_FAILED');
3145: x_return_status := FND_API.G_RET_STS_ERROR;
3146:
3147: END IF;

Line 3334: PA_UTILS.Add_Message( p_app_short_name => 'PA'

3330:
3331:
3332: -- check mandatory version_id
3333: IF (p_object_id IS NULL) then
3334: PA_UTILS.Add_Message( p_app_short_name => 'PA'
3335: ,p_msg_name => 'PA_OBJECT_ID_INV');
3336: x_return_status := FND_API.G_RET_STS_ERROR;
3337: END IF;
3338: l_page_id := -99;

Line 3356: PA_UTILS.Add_Message( p_app_short_name => 'PA'

3352: l_effective_from_date := trunc(sysdate);
3353: End if;
3354:
3355: if (l_page_id = -99) then
3356: PA_UTILS.Add_Message( p_app_short_name => 'PA'
3357: ,p_msg_name => 'PA_NO_PRJ_REP_TEMPLATE');
3358: x_return_status := FND_API.G_RET_STS_ERROR;
3359:
3360: END IF;

Line 3413: PA_UTILS.Add_Message( p_app_short_name => 'PA'

3409:
3410: --debug_msg('before get dates end');
3411:
3412: IF (Trunc(l_report_end_date) < Trunc(l_report_start_date)) THEN
3413: PA_UTILS.Add_Message( p_app_short_name => 'PA'
3414: ,p_msg_name => 'PA_REPORT_END_DATE_INV');
3415: x_return_status := FND_API.G_RET_STS_ERROR;
3416: return;
3417: END IF;

Line 3777: PA_UTILS.Add_Message( p_app_short_name => 'PA'

3773:
3774: FETCH get_object_info INTO l_object_id, l_object_type, l_asof_date;
3775:
3776: IF get_object_info%notfound THEN
3777: PA_UTILS.Add_Message( p_app_short_name => 'PA'
3778: ,p_msg_name => 'PA_NO_PRJ_REP');
3779: x_return_status := FND_API.G_RET_STS_ERROR;
3780: END IF;
3781:

Line 3804: -- PA_UTILS.Add_Message( p_app_short_name => 'PA'

3800:
3801: --debug_msg ('before get_percent_complete' || To_char(l_percent_complete));
3802:
3803: IF get_percent_complete%notfound THEN
3804: -- PA_UTILS.Add_Message( p_app_short_name => 'PA'
3805: -- ,p_msg_name => 'PA_PR_PERCENT_COMPLETE_INV');
3806: -- x_return_status := FND_API.G_RET_STS_ERROR;
3807: NULL;
3808: -- todo when perc complete is null, do we update?

Line 3851: PA_UTILS.Add_Message( p_app_short_name => 'PA'

3847: l_est_start_date, l_est_end_date, l_act_start_date,
3848: l_act_end_date;
3849: IF get_dates%notfound THEN
3850: CLOSE get_dates;
3851: PA_UTILS.Add_Message( p_app_short_name => 'PA'
3852: ,p_msg_name => 'PA_PR_DATES_INV');
3853: x_return_status := FND_API.G_RET_STS_ERROR;
3854:
3855: ROLLBACK TO update_project_perccomplete;