DBA Data[Home] [Help]

APPS.PA_CONTROL_API_PVT dependencies on FND_GLOBAL

Line 143: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE',fnd_global.user_id, fnd_global.resp_id, 275, null, null), 'N');

139:
140:
141: -- initialize the return status to success
142: x_return_status := FND_API.G_RET_STS_SUCCESS;
143: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE',fnd_global.user_id, fnd_global.resp_id, 275, null, null), 'N');
144: if l_debug_mode = 'Y' then
145: pa_debug.set_curr_function(p_function =>l_module_name,p_debug_mode => l_debug_mode);
146: end if;
147:

Line 653: l_debug_mode :=NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.resp_id, 275, null, null), 'N');

649:
650: -- initialize the return status to success
651: x_return_status := FND_API.G_RET_STS_SUCCESS;
652:
653: l_debug_mode :=NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.resp_id, 275, null, null), 'N');
654: if l_debug_mode = 'Y' then
655: pa_debug.set_curr_function(p_function=>l_module_name,p_debug_mode => l_debug_mode);
656: end if;
657:

Line 664: l_org_id := FND_GLOBAL.org_id;

660: pa_debug.g_err_stage:= ' Starting the PA_CONTROL_API_PVT.add_supplier_details ';
661: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
662: end if;
663:
664: l_org_id := FND_GLOBAL.org_id;
665:
666: for i in p_supplier_det_tbl.FIRST .. p_supplier_det_tbl.LAST loop
667:
668: /*get the details of supplier from table type p_supplier_det_tbl*/

Line 1152: ,p_CREATED_BY => FND_GLOBAL.user_id

1148: ,p_CURRENCY_CODE => l_currency_code
1149: ,p_CHANGE_AMOUNT => l_po_line_Amount
1150: ,p_CHANGE_TYPE => p_CHANGE_TYPE
1151: ,p_CHANGE_DESCRIPTION => l_change_description
1152: ,p_CREATED_BY => FND_GLOBAL.user_id
1153: ,p_CREATION_DATE => trunc(sysdate)
1154: ,p_LAST_UPDATED_BY => FND_GLOBAL.user_id
1155: ,p_LAST_UPDATE_DATE => trunc(sysdate)
1156: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id

Line 1154: ,p_LAST_UPDATED_BY => FND_GLOBAL.user_id

1150: ,p_CHANGE_TYPE => p_CHANGE_TYPE
1151: ,p_CHANGE_DESCRIPTION => l_change_description
1152: ,p_CREATED_BY => FND_GLOBAL.user_id
1153: ,p_CREATION_DATE => trunc(sysdate)
1154: ,p_LAST_UPDATED_BY => FND_GLOBAL.user_id
1155: ,p_LAST_UPDATE_DATE => trunc(sysdate)
1156: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id
1157: ,p_ci_status => null
1158: ,x_return_status => x_return_status

Line 1156: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id

1152: ,p_CREATED_BY => FND_GLOBAL.user_id
1153: ,p_CREATION_DATE => trunc(sysdate)
1154: ,p_LAST_UPDATED_BY => FND_GLOBAL.user_id
1155: ,p_LAST_UPDATE_DATE => trunc(sysdate)
1156: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id
1157: ,p_ci_status => null
1158: ,x_return_status => x_return_status
1159: ,x_error_msg_code => l_error_msg_code );
1160:

Line 1291: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.resp_id, 275, null, null), 'N');

1287: -- initialize the return status to success
1288: x_return_status := fnd_api.g_ret_sts_success;
1289: x_msg_count := 0;
1290:
1291: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.resp_id, 275, null, null), 'N');
1292: l_module_name := 'check_create_ci_allowed' || g_module_name;
1293:
1294: if l_debug_mode = 'Y' then
1295: pa_debug.set_curr_function(p_function => 'pa_control_api_pvt.check_create_ci_allowed', p_debug_mode => l_debug_mode);

Line 1789: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.resp_id, 275, null, null), 'N');

1785: -- initialize the return status to success
1786: x_return_status := fnd_api.g_ret_sts_success;
1787: x_msg_count := 0;
1788:
1789: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.resp_id, 275, null, null), 'N');
1790: l_module_name := 'validate_param_and_create' || g_module_name;
1791:
1792: if l_debug_mode = 'Y' then
1793: pa_debug.set_curr_function(p_function => 'pa_control_api_pvt.validate_param_and_create', p_debug_mode => l_debug_mode);

Line 1804: l_user_id := fnd_global.user_id;

1800: --setting the err occured flag to N initially.
1801: l_any_err_occured_flg := 'N';
1802:
1803: --get the user id and the party id for the current logged in user.
1804: l_user_id := fnd_global.user_id;
1805: l_party_id := pa_control_items_utils.getpartyid(l_user_id);
1806: l_resp_id := fnd_global.resp_id;
1807:
1808: if(p_summary is null) then

Line 1806: l_resp_id := fnd_global.resp_id;

1802:
1803: --get the user id and the party id for the current logged in user.
1804: l_user_id := fnd_global.user_id;
1805: l_party_id := pa_control_items_utils.getpartyid(l_user_id);
1806: l_resp_id := fnd_global.resp_id;
1807:
1808: if(p_summary is null) then
1809: PA_UTILS.ADD_MESSAGE
1810: (p_app_short_name => 'PA',

Line 2454: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.resp_id, 275, null, null), 'N');

2450: -- initialize the return status to success
2451: x_return_status := fnd_api.g_ret_sts_success;
2452: x_msg_count := 0;
2453:
2454: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.resp_id, 275, null, null), 'N');
2455: l_module_name := 'check_create_action_allow' || g_module_name;
2456:
2457: if l_debug_mode = 'Y' then
2458: pa_debug.set_curr_function(p_function => 'pa_control_api_pvt.check_create_action_allow', p_debug_mode => l_debug_mode);

Line 2620: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.resp_id, 275, null, null), 'N');

2616: -- initialize the return status to success
2617: x_return_status := fnd_api.g_ret_sts_success;
2618: x_msg_count := 0;
2619:
2620: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.resp_id, 275, null, null), 'N');
2621: l_module_name := 'validate_assignee_id' || g_module_name;
2622:
2623: if l_debug_mode = 'Y' then
2624: pa_debug.set_curr_function(p_function => 'pa_control_api_pvt.validate_assignee_id', p_debug_mode => l_debug_mode);

Line 2791: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.resp_id, 275, null, null), 'N');

2787: -- initialize the return status to success
2788: x_return_status := fnd_api.g_ret_sts_success;
2789: x_msg_count := 0;
2790:
2791: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.resp_id, 275, null, null), 'N');
2792: l_module_name := 'validate_action_attributes' || g_module_name;
2793:
2794: if l_debug_mode = 'Y' then
2795: pa_debug.set_curr_function(p_function => 'pa_control_api_pvt.validate_action_attributes', p_debug_mode => l_debug_mode);

Line 3113: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.resp_id, 275, null, null), 'N');

3109: -- initialize the return status to success
3110: x_return_status := fnd_api.g_ret_sts_success;
3111: x_msg_count := 0;
3112:
3113: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.resp_id, 275, null, null), 'N');
3114: l_module_name := 'create_action' || g_module_name;
3115:
3116: if l_debug_mode = 'Y' then
3117: pa_debug.set_curr_function(p_function => 'pa_control_api_pvt.create_action', p_debug_mode => l_debug_mode);

Line 3162: p_last_updated_by => fnd_global.user_id,

3158: p_sign_off_required_flag => p_action_tbl(i).sign_off_requested_flag,
3159: p_date_closed => p_action_tbl(i).closed_date,
3160: p_sign_off_flag => p_action_tbl(i).signed_off,
3161: p_source_ci_action_id => p_action_tbl(i).source_ci_action_id,
3162: p_last_updated_by => fnd_global.user_id,
3163: p_created_by => fnd_global.user_id,
3164: p_creation_date => sysdate,
3165: p_last_update_date => sysdate,
3166: p_last_update_login => fnd_global.login_id, --this shd not be user_id.

Line 3163: p_created_by => fnd_global.user_id,

3159: p_date_closed => p_action_tbl(i).closed_date,
3160: p_sign_off_flag => p_action_tbl(i).signed_off,
3161: p_source_ci_action_id => p_action_tbl(i).source_ci_action_id,
3162: p_last_updated_by => fnd_global.user_id,
3163: p_created_by => fnd_global.user_id,
3164: p_creation_date => sysdate,
3165: p_last_update_date => sysdate,
3166: p_last_update_login => fnd_global.login_id, --this shd not be user_id.
3167: p_record_version_number => 1);

Line 3166: p_last_update_login => fnd_global.login_id, --this shd not be user_id.

3162: p_last_updated_by => fnd_global.user_id,
3163: p_created_by => fnd_global.user_id,
3164: p_creation_date => sysdate,
3165: p_last_update_date => sysdate,
3166: p_last_update_login => fnd_global.login_id, --this shd not be user_id.
3167: p_record_version_number => 1);
3168:
3169: /* now prepare the output table to store the output values*/
3170: x_action_tbl(i).action_id := l_ci_action_id;

Line 3191: p_last_updated_by => fnd_global.user_id,

3187: p_ci_comment_id => l_ci_comment_id,
3188: p_ci_id => p_ci_id,
3189: p_type_code => l_type_code,
3190: p_comment_text => p_action_tbl(i).request_text,
3191: p_last_updated_by => fnd_global.user_id,
3192: p_created_by => fnd_global.user_id,
3193: p_creation_date => sysdate,
3194: p_last_update_date => sysdate,
3195: p_last_update_login => fnd_global.login_id, --this shd not be user_id

Line 3192: p_created_by => fnd_global.user_id,

3188: p_ci_id => p_ci_id,
3189: p_type_code => l_type_code,
3190: p_comment_text => p_action_tbl(i).request_text,
3191: p_last_updated_by => fnd_global.user_id,
3192: p_created_by => fnd_global.user_id,
3193: p_creation_date => sysdate,
3194: p_last_update_date => sysdate,
3195: p_last_update_login => fnd_global.login_id, --this shd not be user_id
3196: p_ci_action_id => l_ci_action_id);

Line 3195: p_last_update_login => fnd_global.login_id, --this shd not be user_id

3191: p_last_updated_by => fnd_global.user_id,
3192: p_created_by => fnd_global.user_id,
3193: p_creation_date => sysdate,
3194: p_last_update_date => sysdate,
3195: p_last_update_login => fnd_global.login_id, --this shd not be user_id
3196: p_ci_action_id => l_ci_action_id);
3197:
3198:
3199: if l_debug_mode = 'Y' then

Line 3372: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.resp_id, 275, null, null), 'N');

3368: -- initialize the return status to success
3369: x_return_status := fnd_api.g_ret_sts_success;
3370: x_msg_count := 0;
3371:
3372: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.resp_id, 275, null, null), 'N');
3373: l_module_name := 'validate_priv_and_action' || g_module_name;
3374:
3375: if l_debug_mode = 'Y' then
3376: pa_debug.set_curr_function(p_function => 'pa_control_api_pub.validate_priv_and_action', p_debug_mode => l_debug_mode);

Line 3548: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.resp_id, 275, null, null), 'N');

3544: l_Msg_Index_Out NUMBER;
3545: l_CiId PA_CONTROL_ITEMS.Ci_Id%TYPE;
3546: -- End: Local Variables.
3547: BEGIN
3548: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.resp_id, 275, null, null), 'N');
3549: l_module_name := 'Delete_CI' || g_module_name;
3550:
3551: if l_debug_mode = 'Y' then
3552: pa_debug.set_curr_function(p_function => 'pa_control_api_pub.Delete_CI', p_debug_mode => l_debug_mode);