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_CORE1 dependencies on FND_API

Line 115: p_encoded => FND_API.G_TRUE,

111: x_msg_count := FND_MSG_PUB.count_msg;
112:
113: FND_MSG_PUB.get (
114: p_msg_index => 1,
115: p_encoded => FND_API.G_TRUE,
116: p_data => l_data,
117: p_msg_index_out => l_msg_index_out );
118:
119: if l_data is not null then

Line 1179: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

1175: ,x_return_status => l_return_status
1176: ,x_msg_count => l_msg_count
1177: ,x_msg_data => l_msg_data
1178: );
1179: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1180: ROLLBACK TO copy_project;
1181: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
1182: x_err_code := 199;
1183: x_err_stage := 'API: '||'PA_PROJECT_CORE1.POPULATE_DEFAULT_COPY_OPTIONS'||

Line 1717: ,p_init_msg_list => FND_API.G_FALSE

1713:
1714: PA_PJP_PVT.Submit_Project_Aw -- Changed from FPA_PROCESS_PVT to PA_PJP_PVT package
1715: (
1716: p_api_version => 1.0
1717: ,p_init_msg_list => FND_API.G_FALSE
1718: ,p_commit => FND_API.G_FALSE
1719: ,p_project_id => x_new_project_id
1720: ,x_return_status => l_return_status
1721: ,x_msg_count => l_msg_count

Line 1718: ,p_commit => FND_API.G_FALSE

1714: PA_PJP_PVT.Submit_Project_Aw -- Changed from FPA_PROCESS_PVT to PA_PJP_PVT package
1715: (
1716: p_api_version => 1.0
1717: ,p_init_msg_list => FND_API.G_FALSE
1718: ,p_commit => FND_API.G_FALSE
1719: ,p_project_id => x_new_project_id
1720: ,x_return_status => l_return_status
1721: ,x_msg_count => l_msg_count
1722: ,x_msg_data => l_msg_data

Line 1867: ,p_init_msg_list => FND_API.G_TRUE

1863: ,p_object_id => x_new_project_id
1864: ,p_description => l_description
1865: ,p_record_version_number => 1
1866: ,p_calling_module => 'PROJECT_SUBTEAMS'
1867: ,p_init_msg_list => FND_API.G_TRUE
1868: ,p_validate_only => FND_API.G_FALSE
1869: ,x_new_subteam_id => l_new_subteam_id
1870: ,x_subteam_row_id => l_subteam_row_id
1871: ,x_return_status => l_return_status

Line 1868: ,p_validate_only => FND_API.G_FALSE

1864: ,p_description => l_description
1865: ,p_record_version_number => 1
1866: ,p_calling_module => 'PROJECT_SUBTEAMS'
1867: ,p_init_msg_list => FND_API.G_TRUE
1868: ,p_validate_only => FND_API.G_FALSE
1869: ,x_new_subteam_id => l_new_subteam_id
1870: ,x_subteam_row_id => l_subteam_row_id
1871: ,x_return_status => l_return_status
1872: ,x_msg_count => l_msg_count

Line 1989: ( p_validate_only => FND_API.G_FALSE

1985: CLOSE l_get_workplan_attrs_csr;
1986:
1987: BEGIN
1988: PA_WORKPLAN_ATTR_PUB.CREATE_PROJ_WORKPLAN_ATTRS
1989: ( p_validate_only => FND_API.G_FALSE
1990: ,p_project_id => x_new_project_id
1991: ,p_approval_reqd_flag => l_approval_reqd_flag
1992: ,p_auto_publish_flag => l_auto_publish_flag
1993: ,p_approver_source_id => l_approver_source_id

Line 2196: , p_init_msg_list => FND_API.G_TRUE -- p_init_msg_list

2192: --bug 2778730
2193: /* Bug 3022296 : End */
2194: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
2195: p_api_version => 1.0 -- p_api_version
2196: , p_init_msg_list => FND_API.G_TRUE -- p_init_msg_list
2197: , p_commit => FND_API.G_FALSE -- p_commit
2198: , p_validate_only => FND_API.G_FALSE -- p_validate_only
2199: , p_validation_level => FND_API.G_VALID_LEVEL_FULL -- p_validation_level
2200: , p_debug_mode => 'N' -- p_debug_mode

Line 2197: , p_commit => FND_API.G_FALSE -- p_commit

2193: /* Bug 3022296 : End */
2194: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
2195: p_api_version => 1.0 -- p_api_version
2196: , p_init_msg_list => FND_API.G_TRUE -- p_init_msg_list
2197: , p_commit => FND_API.G_FALSE -- p_commit
2198: , p_validate_only => FND_API.G_FALSE -- p_validate_only
2199: , p_validation_level => FND_API.G_VALID_LEVEL_FULL -- p_validation_level
2200: , p_debug_mode => 'N' -- p_debug_mode
2201: , p_object_id => x_new_project_id -- p_object_id

Line 2198: , p_validate_only => FND_API.G_FALSE -- p_validate_only

2194: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
2195: p_api_version => 1.0 -- p_api_version
2196: , p_init_msg_list => FND_API.G_TRUE -- p_init_msg_list
2197: , p_commit => FND_API.G_FALSE -- p_commit
2198: , p_validate_only => FND_API.G_FALSE -- p_validate_only
2199: , p_validation_level => FND_API.G_VALID_LEVEL_FULL -- p_validation_level
2200: , p_debug_mode => 'N' -- p_debug_mode
2201: , p_object_id => x_new_project_id -- p_object_id
2202: , p_OBJECT_TYPE => 'PA_PROJECTS' -- p_OBJECT_TYPE

Line 2199: , p_validation_level => FND_API.G_VALID_LEVEL_FULL -- p_validation_level

2195: p_api_version => 1.0 -- p_api_version
2196: , p_init_msg_list => FND_API.G_TRUE -- p_init_msg_list
2197: , p_commit => FND_API.G_FALSE -- p_commit
2198: , p_validate_only => FND_API.G_FALSE -- p_validate_only
2199: , p_validation_level => FND_API.G_VALID_LEVEL_FULL -- p_validation_level
2200: , p_debug_mode => 'N' -- p_debug_mode
2201: , p_object_id => x_new_project_id -- p_object_id
2202: , p_OBJECT_TYPE => 'PA_PROJECTS' -- p_OBJECT_TYPE
2203: , p_project_role_id => v_null_number -- p_project_role_id

Line 2359: , p_init_msg_list => FND_API.G_TRUE -- p_init_msg_list

2355: /* Bug 7482391 changes end here*/
2356: if (f_flag = 'Y') then -- Bug 7482391
2357: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
2358: p_api_version => 1.0 -- p_api_version
2359: , p_init_msg_list => FND_API.G_TRUE -- p_init_msg_list
2360: , p_commit => FND_API.G_FALSE -- p_commit
2361: , p_validate_only => FND_API.G_FALSE -- p_validate_only
2362: , p_validation_level => FND_API.G_VALID_LEVEL_FULL -- p_validation_level
2363: , p_debug_mode => 'N' -- p_debug_mode

Line 2360: , p_commit => FND_API.G_FALSE -- p_commit

2356: if (f_flag = 'Y') then -- Bug 7482391
2357: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
2358: p_api_version => 1.0 -- p_api_version
2359: , p_init_msg_list => FND_API.G_TRUE -- p_init_msg_list
2360: , p_commit => FND_API.G_FALSE -- p_commit
2361: , p_validate_only => FND_API.G_FALSE -- p_validate_only
2362: , p_validation_level => FND_API.G_VALID_LEVEL_FULL -- p_validation_level
2363: , p_debug_mode => 'N' -- p_debug_mode
2364: , p_object_id => x_new_project_id -- p_object_id

Line 2361: , p_validate_only => FND_API.G_FALSE -- p_validate_only

2357: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
2358: p_api_version => 1.0 -- p_api_version
2359: , p_init_msg_list => FND_API.G_TRUE -- p_init_msg_list
2360: , p_commit => FND_API.G_FALSE -- p_commit
2361: , p_validate_only => FND_API.G_FALSE -- p_validate_only
2362: , p_validation_level => FND_API.G_VALID_LEVEL_FULL -- p_validation_level
2363: , p_debug_mode => 'N' -- p_debug_mode
2364: , p_object_id => x_new_project_id -- p_object_id
2365: , p_OBJECT_TYPE => 'PA_PROJECTS' -- p_OBJECT_TYPE

Line 2362: , p_validation_level => FND_API.G_VALID_LEVEL_FULL -- p_validation_level

2358: p_api_version => 1.0 -- p_api_version
2359: , p_init_msg_list => FND_API.G_TRUE -- p_init_msg_list
2360: , p_commit => FND_API.G_FALSE -- p_commit
2361: , p_validate_only => FND_API.G_FALSE -- p_validate_only
2362: , p_validation_level => FND_API.G_VALID_LEVEL_FULL -- p_validation_level
2363: , p_debug_mode => 'N' -- p_debug_mode
2364: , p_object_id => x_new_project_id -- p_object_id
2365: , p_OBJECT_TYPE => 'PA_PROJECTS' -- p_OBJECT_TYPE
2366: , p_project_role_id => v_null_number -- p_project_role_id

Line 2538: , p_init_msg_list => FND_API.G_TRUE

2534: -- a customer billing account
2535: if c_cust_created_org_csr%NOTFOUND then
2536: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
2537: p_api_version => 1.0
2538: , p_init_msg_list => FND_API.G_TRUE
2539: , p_commit => FND_API.G_FALSE
2540: , p_validate_only => FND_API.G_FALSE
2541: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
2542: , p_debug_mode => 'N'

Line 2539: , p_commit => FND_API.G_FALSE

2535: if c_cust_created_org_csr%NOTFOUND then
2536: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
2537: p_api_version => 1.0
2538: , p_init_msg_list => FND_API.G_TRUE
2539: , p_commit => FND_API.G_FALSE
2540: , p_validate_only => FND_API.G_FALSE
2541: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
2542: , p_debug_mode => 'N'
2543: , p_object_id => x_new_project_id

Line 2540: , p_validate_only => FND_API.G_FALSE

2536: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
2537: p_api_version => 1.0
2538: , p_init_msg_list => FND_API.G_TRUE
2539: , p_commit => FND_API.G_FALSE
2540: , p_validate_only => FND_API.G_FALSE
2541: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
2542: , p_debug_mode => 'N'
2543: , p_object_id => x_new_project_id
2544: , p_OBJECT_TYPE => 'PA_PROJECTS'

Line 2541: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

2537: p_api_version => 1.0
2538: , p_init_msg_list => FND_API.G_TRUE
2539: , p_commit => FND_API.G_FALSE
2540: , p_validate_only => FND_API.G_FALSE
2541: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
2542: , p_debug_mode => 'N'
2543: , p_object_id => x_new_project_id
2544: , p_OBJECT_TYPE => 'PA_PROJECTS'
2545: , p_project_role_id => v_null_number

Line 2604: , p_init_msg_list => FND_API.G_TRUE

2600: -- a customer billing account
2601: if c_cust_created_org_csr%NOTFOUND then
2602: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
2603: p_api_version => 1.0
2604: , p_init_msg_list => FND_API.G_TRUE
2605: , p_commit => FND_API.G_FALSE
2606: , p_validate_only => FND_API.G_FALSE
2607: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
2608: , p_debug_mode => 'N'

Line 2605: , p_commit => FND_API.G_FALSE

2601: if c_cust_created_org_csr%NOTFOUND then
2602: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
2603: p_api_version => 1.0
2604: , p_init_msg_list => FND_API.G_TRUE
2605: , p_commit => FND_API.G_FALSE
2606: , p_validate_only => FND_API.G_FALSE
2607: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
2608: , p_debug_mode => 'N'
2609: , p_object_id => x_new_project_id

Line 2606: , p_validate_only => FND_API.G_FALSE

2602: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
2603: p_api_version => 1.0
2604: , p_init_msg_list => FND_API.G_TRUE
2605: , p_commit => FND_API.G_FALSE
2606: , p_validate_only => FND_API.G_FALSE
2607: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
2608: , p_debug_mode => 'N'
2609: , p_object_id => x_new_project_id
2610: , p_OBJECT_TYPE => 'PA_PROJECTS'

Line 2607: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

2603: p_api_version => 1.0
2604: , p_init_msg_list => FND_API.G_TRUE
2605: , p_commit => FND_API.G_FALSE
2606: , p_validate_only => FND_API.G_FALSE
2607: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
2608: , p_debug_mode => 'N'
2609: , p_object_id => x_new_project_id
2610: , p_OBJECT_TYPE => 'PA_PROJECTS'
2611: , p_project_role_id => v_null_number

Line 3069: p_validate_only => FND_API.G_FALSE

3065:
3066: if l_party_id is not null then
3067:
3068: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
3069: p_validate_only => FND_API.G_FALSE
3070: , p_object_id => x_new_project_id
3071: , p_OBJECT_TYPE => 'PA_PROJECTS'
3072: , p_project_role_id => 100
3073: , p_project_role_type => 'CUSTOMER_ORG'

Line 3459: IF (l_copy_bill_to_contact_id IS NULL OR l_copy_bill_to_contact_id= FND_API.G_MISS_NUM) THEN

3455: --Added the following if conditions for Bug#4770535.If there is no billing or shipping contact for this customer,
3456: --we should not copy the values returned from get_customer_info by mistake as it gives the contact at primary site.
3457:
3458:
3459: IF (l_copy_bill_to_contact_id IS NULL OR l_copy_bill_to_contact_id= FND_API.G_MISS_NUM) THEN
3460: l_bill_to_contact_id := NULL;
3461: END IF;
3462:
3463: IF (l_copy_ship_to_contact_id IS NULL OR l_copy_ship_to_contact_id = FND_API.G_MISS_NUM) THEN

Line 3463: IF (l_copy_ship_to_contact_id IS NULL OR l_copy_ship_to_contact_id = FND_API.G_MISS_NUM) THEN

3459: IF (l_copy_bill_to_contact_id IS NULL OR l_copy_bill_to_contact_id= FND_API.G_MISS_NUM) THEN
3460: l_bill_to_contact_id := NULL;
3461: END IF;
3462:
3463: IF (l_copy_ship_to_contact_id IS NULL OR l_copy_ship_to_contact_id = FND_API.G_MISS_NUM) THEN
3464: l_ship_to_contact_id := NULL;
3465: END IF;
3466:
3467:

Line 3789: p_validate_only => FND_API.G_FALSE

3785:
3786: if l_party_id is not null then
3787:
3788: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
3789: p_validate_only => FND_API.G_FALSE
3790: , p_object_id => x_new_project_id
3791: , p_OBJECT_TYPE => 'PA_PROJECTS'
3792: , p_project_role_id => 100
3793: , p_project_role_type => 'CUSTOMER_ORG'

Line 5291: IF l_return_status <> fnd_api.g_ret_sts_success

5287: P_object_id_to => x_new_project_id,
5288: x_return_status => l_return_status,
5289: x_msg_count => l_msg_count,
5290: x_msg_data => l_msg_data );
5291: IF l_return_status <> fnd_api.g_ret_sts_success
5292: THEN
5293: x_err_code := 730;
5294: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_COPY_OBJ_PG_LAY');
5295: x_err_stack := x_err_stack||'->PA_Page_layout_Utils.copy_object_page_layouts';

Line 5322: IF l_return_status <> fnd_api.g_ret_sts_success

5318: p_project_id_to => x_new_project_id,
5319: x_return_status => l_return_status,
5320: x_msg_count => l_msg_count,
5321: x_msg_data => l_msg_data );
5322: IF l_return_status <> fnd_api.g_ret_sts_success
5323: THEN
5324: x_err_code := 844;
5325: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_COPY_PROJ_ACTSET');
5326: x_err_stack := x_err_stack||'->PA_PROJ_STAT_ACTSET.copy_action_sets';

Line 5351: IF l_return_status <> fnd_api.g_ret_sts_success

5347: p_project_id_to => x_new_project_id,
5348: x_return_status => l_return_status,
5349: x_msg_count => l_msg_count,
5350: x_msg_data => l_msg_data );
5351: IF l_return_status <> fnd_api.g_ret_sts_success
5352: THEN
5353: x_err_code := 866;
5354: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_COPY_TASK_ACTSET');
5355: x_err_stack := x_err_stack||'->PA_TASK_PROG_ACTSET.copy_action_sets';

Line 5387: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

5383: ,x_return_status => l_return_status
5384: ,x_msg_count => l_msg_count
5385: ,x_msg_data => l_msg_data );
5386:
5387: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
5388: x_err_code := 880;
5389: x_err_stage := pa_project_core1.get_message_from_stack('PA_PERF_COPY_RULES_ERR');
5390: x_err_stack := x_err_stack||'->PA_PERF_EXCP_UTILS.copy_object_rule_assoc';
5391: rollback to copy_project;

Line 5419: ,p_init_msg_list => fnd_api.g_FALSE

5415: IF 'Y' = l_pr_item_assoc_flag THEN
5416: PA_EGO_WRAPPER_PUB.COPY_ITEM_ASSOCS
5417: ( p_project_id_from => x_orig_project_id
5418: ,p_project_id_to => x_new_project_id
5419: ,p_init_msg_list => fnd_api.g_FALSE
5420: ,p_commit => fnd_api.g_FALSE
5421: ,x_return_status => l_return_status
5422: ,x_errorcode => l_errorcode
5423: ,x_msg_count => l_msg_count

Line 5420: ,p_commit => fnd_api.g_FALSE

5416: PA_EGO_WRAPPER_PUB.COPY_ITEM_ASSOCS
5417: ( p_project_id_from => x_orig_project_id
5418: ,p_project_id_to => x_new_project_id
5419: ,p_init_msg_list => fnd_api.g_FALSE
5420: ,p_commit => fnd_api.g_FALSE
5421: ,x_return_status => l_return_status
5422: ,x_errorcode => l_errorcode
5423: ,x_msg_count => l_msg_count
5424: ,x_msg_data => l_msg_data);

Line 5503: IF l_return_status <> fnd_api.g_ret_sts_success

5499: ,x_return_status => l_return_status
5500: ,x_msg_count => l_msg_count
5501: ,x_msg_data => l_msg_data
5502: );
5503: IF l_return_status <> fnd_api.g_ret_sts_success
5504: THEN
5505: x_err_code := 735;
5506: x_err_stage := pa_project_core1.get_message_from_stack('PA_ERR_INSERT_ACCUM');
5507: x_err_stack := x_err_stack||'->pa_accum_proj_list.Insert_Accum';

Line 5615: IF l_return_status <> fnd_api.g_ret_sts_success

5611: ,x_return_status => l_return_status
5612: ,x_msg_count => l_msg_count
5613: ,x_msg_data => l_msg_data
5614: );
5615: IF l_return_status <> fnd_api.g_ret_sts_success
5616: THEN
5617: IF l_msg_data IS NULL THEN
5618: l_msg_data := 'PA_ERR_COPY_FINPLANS';
5619: END IF ;

Line 6084: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

6080: --
6081: -- HISTORY
6082: -- 11-MAR-2004 sabansal Created
6083: PROCEDURE populate_copy_options( p_api_version IN NUMBER := 1.0
6084: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
6085: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
6086: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
6087: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
6088: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

Line 6085: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

6081: -- HISTORY
6082: -- 11-MAR-2004 sabansal Created
6083: PROCEDURE populate_copy_options( p_api_version IN NUMBER := 1.0
6084: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
6085: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
6086: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
6087: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
6088: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
6089: ,p_debug_mode IN VARCHAR2 := 'N'

Line 6086: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

6082: -- 11-MAR-2004 sabansal Created
6083: PROCEDURE populate_copy_options( p_api_version IN NUMBER := 1.0
6084: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
6085: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
6086: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
6087: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
6088: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
6089: ,p_debug_mode IN VARCHAR2 := 'N'
6090: ,p_context_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE()

Line 6087: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

6083: PROCEDURE populate_copy_options( p_api_version IN NUMBER := 1.0
6084: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
6085: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
6086: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
6087: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
6088: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
6089: ,p_debug_mode IN VARCHAR2 := 'N'
6090: ,p_context_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
6091: ,p_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE()

Line 6105: x_return_status := FND_API.G_RET_STS_SUCCESS;

6101: l_debug_level5 CONSTANT NUMBER := 5;
6102: BEGIN
6103:
6104: x_msg_count := 0;
6105: x_return_status := FND_API.G_RET_STS_SUCCESS;
6106: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
6107:
6108: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
6109: FND_MSG_PUB.initialize;

Line 6108: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN

6104: x_msg_count := 0;
6105: x_return_status := FND_API.G_RET_STS_SUCCESS;
6106: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
6107:
6108: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
6109: FND_MSG_PUB.initialize;
6110: END IF;
6111:
6112: IF (p_commit = FND_API.G_TRUE) THEN

Line 6112: IF (p_commit = FND_API.G_TRUE) THEN

6108: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
6109: FND_MSG_PUB.initialize;
6110: END IF;
6111:
6112: IF (p_commit = FND_API.G_TRUE) THEN
6113: SAVEPOINT pop_copy_options;
6114: END IF;
6115:
6116: IF l_debug_mode = 'Y' THEN

Line 6161: IF (p_commit = FND_API.G_TRUE) THEN

6157: );
6158: END LOOP;
6159: END IF;
6160:
6161: IF (p_commit = FND_API.G_TRUE) THEN
6162: COMMIT;
6163: END IF;
6164:
6165: EXCEPTION

Line 6167: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

6163: END IF;
6164:
6165: EXCEPTION
6166: WHEN OTHERS THEN
6167: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
6168: x_msg_count := 1;
6169: x_msg_data := SQLERRM;
6170:
6171: IF p_commit = FND_API.G_TRUE THEN

Line 6171: IF p_commit = FND_API.G_TRUE THEN

6167: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
6168: x_msg_count := 1;
6169: x_msg_data := SQLERRM;
6170:
6171: IF p_commit = FND_API.G_TRUE THEN
6172: ROLLBACK TO pop_copy_options;
6173: END IF;
6174:
6175: Fnd_Msg_Pub.add_exc_msg

Line 6204: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

6200: -- options would be populated
6201: -- p_src_template_flag VARCHAR2 Y Whether the source is a project or a template
6202: -- p_dest_template_flag VARCHAR2 Y Whether creating a project or a template
6203: PROCEDURE populate_default_copy_options( p_api_version IN NUMBER := 1.0
6204: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
6205: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
6206: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
6207: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
6208: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

Line 6205: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

6201: -- p_src_template_flag VARCHAR2 Y Whether the source is a project or a template
6202: -- p_dest_template_flag VARCHAR2 Y Whether creating a project or a template
6203: PROCEDURE populate_default_copy_options( p_api_version IN NUMBER := 1.0
6204: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
6205: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
6206: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
6207: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
6208: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
6209: ,p_debug_mode IN VARCHAR2 := 'N'

Line 6206: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

6202: -- p_dest_template_flag VARCHAR2 Y Whether creating a project or a template
6203: PROCEDURE populate_default_copy_options( p_api_version IN NUMBER := 1.0
6204: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
6205: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
6206: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
6207: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
6208: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
6209: ,p_debug_mode IN VARCHAR2 := 'N'
6210: ,p_src_project_id IN NUMBER

Line 6207: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

6203: PROCEDURE populate_default_copy_options( p_api_version IN NUMBER := 1.0
6204: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
6205: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
6206: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
6207: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
6208: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
6209: ,p_debug_mode IN VARCHAR2 := 'N'
6210: ,p_src_project_id IN NUMBER
6211: ,p_src_template_flag IN VARCHAR2

Line 6267: x_return_status := FND_API.G_RET_STS_SUCCESS;

6263:
6264: BEGIN
6265:
6266: x_msg_count := 0;
6267: x_return_status := FND_API.G_RET_STS_SUCCESS;
6268: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
6269:
6270: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
6271: FND_MSG_PUB.initialize;

Line 6270: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN

6266: x_msg_count := 0;
6267: x_return_status := FND_API.G_RET_STS_SUCCESS;
6268: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
6269:
6270: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
6271: FND_MSG_PUB.initialize;
6272: END IF;
6273:
6274: IF (p_commit = FND_API.G_TRUE) THEN

Line 6274: IF (p_commit = FND_API.G_TRUE) THEN

6270: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
6271: FND_MSG_PUB.initialize;
6272: END IF;
6273:
6274: IF (p_commit = FND_API.G_TRUE) THEN
6275: SAVEPOINT def_copy_options;
6276: END IF;
6277:
6278: IF l_debug_mode = 'Y' THEN

Line 6304: IF ( ( p_src_project_id IS NULL OR p_src_project_id = FND_API.G_MISS_NUM ) AND

6300: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
6301: l_debug_level3);
6302: END IF;
6303:
6304: IF ( ( p_src_project_id IS NULL OR p_src_project_id = FND_API.G_MISS_NUM ) AND
6305: ( p_src_template_flag IS NULL OR p_src_template_flag = FND_API.G_MISS_CHAR )
6306: )
6307: THEN
6308: IF l_debug_mode = 'Y' THEN

Line 6305: ( p_src_template_flag IS NULL OR p_src_template_flag = FND_API.G_MISS_CHAR )

6301: l_debug_level3);
6302: END IF;
6303:
6304: IF ( ( p_src_project_id IS NULL OR p_src_project_id = FND_API.G_MISS_NUM ) AND
6305: ( p_src_template_flag IS NULL OR p_src_template_flag = FND_API.G_MISS_CHAR )
6306: )
6307: THEN
6308: IF l_debug_mode = 'Y' THEN
6309: Pa_Debug.g_err_stage:= 'PA_PROJECT_CORE1 : populate_default_copy_options :

Line 6452: IF (p_commit = FND_API.G_TRUE) THEN

6448: END IF;--IF 'Y' = l_workplan_enabled AND cur_wp_record_present%NOTFOUND
6449:
6450: CLOSE cur_wp_record_present;
6451:
6452: IF (p_commit = FND_API.G_TRUE) THEN
6453: COMMIT;
6454: END IF;
6455:
6456: EXCEPTION

Line 6458: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

6454: END IF;
6455:
6456: EXCEPTION
6457: WHEN Invalid_Arg_Exc THEN
6458: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
6459: x_msg_count := 1;
6460: x_msg_data := ' PA_PROJECT_CORE1 : populate_default_copy_options : NULL parameters passed';
6461:
6462: IF p_commit = FND_API.G_TRUE THEN

Line 6462: IF p_commit = FND_API.G_TRUE THEN

6458: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
6459: x_msg_count := 1;
6460: x_msg_data := ' PA_PROJECT_CORE1 : populate_default_copy_options : NULL parameters passed';
6461:
6462: IF p_commit = FND_API.G_TRUE THEN
6463: ROLLBACK TO def_copy_options;
6464: END IF;
6465:
6466: Fnd_Msg_Pub.add_exc_msg

Line 6480: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

6476: END IF;
6477: RAISE;
6478:
6479: WHEN OTHERS THEN
6480: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
6481: x_msg_count := 1;
6482: x_msg_data := SQLERRM;
6483:
6484: IF p_commit = FND_API.G_TRUE THEN

Line 6484: IF p_commit = FND_API.G_TRUE THEN

6480: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
6481: x_msg_count := 1;
6482: x_msg_data := SQLERRM;
6483:
6484: IF p_commit = FND_API.G_TRUE THEN
6485: ROLLBACK TO def_copy_options;
6486: END IF;
6487:
6488: Fnd_Msg_Pub.add_exc_msg