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 657: l_debug_mode :=NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.resp_id, 275, null, null), 'N');

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

Line 668: l_org_id := FND_GLOBAL.org_id;

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

Line 1156: ,p_CREATED_BY => FND_GLOBAL.user_id

1152: ,p_CURRENCY_CODE => l_currency_code
1153: ,p_CHANGE_AMOUNT => l_po_line_Amount
1154: ,p_CHANGE_TYPE => p_CHANGE_TYPE
1155: ,p_CHANGE_DESCRIPTION => l_change_description
1156: ,p_CREATED_BY => FND_GLOBAL.user_id
1157: ,p_CREATION_DATE => trunc(sysdate)
1158: ,p_LAST_UPDATED_BY => FND_GLOBAL.user_id
1159: ,p_LAST_UPDATE_DATE => trunc(sysdate)
1160: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id

Line 1158: ,p_LAST_UPDATED_BY => FND_GLOBAL.user_id

1154: ,p_CHANGE_TYPE => p_CHANGE_TYPE
1155: ,p_CHANGE_DESCRIPTION => l_change_description
1156: ,p_CREATED_BY => FND_GLOBAL.user_id
1157: ,p_CREATION_DATE => trunc(sysdate)
1158: ,p_LAST_UPDATED_BY => FND_GLOBAL.user_id
1159: ,p_LAST_UPDATE_DATE => trunc(sysdate)
1160: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id
1161: ,p_Task_Id => NULL
1162: ,p_Resource_List_Mem_Id => NULL

Line 1160: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id

1156: ,p_CREATED_BY => FND_GLOBAL.user_id
1157: ,p_CREATION_DATE => trunc(sysdate)
1158: ,p_LAST_UPDATED_BY => FND_GLOBAL.user_id
1159: ,p_LAST_UPDATE_DATE => trunc(sysdate)
1160: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id
1161: ,p_Task_Id => NULL
1162: ,p_Resource_List_Mem_Id => NULL
1163: ,p_From_Date => NULL
1164: ,p_To_Date => NULL

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

1304: -- initialize the return status to success
1305: x_return_status := fnd_api.g_ret_sts_success;
1306: x_msg_count := 0;
1307:
1308: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.resp_id, 275, null, null), 'N');
1309: l_module_name := 'check_create_ci_allowed' || g_module_name;
1310:
1311: if l_debug_mode = 'Y' then
1312: pa_debug.set_curr_function(p_function => 'pa_control_api_pvt.check_create_ci_allowed', p_debug_mode => l_debug_mode);

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

1802: -- initialize the return status to success
1803: x_return_status := fnd_api.g_ret_sts_success;
1804: x_msg_count := 0;
1805:
1806: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.resp_id, 275, null, null), 'N');
1807: l_module_name := 'validate_param_and_create' || g_module_name;
1808:
1809: if l_debug_mode = 'Y' then
1810: pa_debug.set_curr_function(p_function => 'pa_control_api_pvt.validate_param_and_create', p_debug_mode => l_debug_mode);

Line 1821: l_user_id := fnd_global.user_id;

1817: --setting the err occured flag to N initially.
1818: l_any_err_occured_flg := 'N';
1819:
1820: --get the user id and the party id for the current logged in user.
1821: l_user_id := fnd_global.user_id;
1822: l_party_id := pa_control_items_utils.getpartyid(l_user_id);
1823: l_resp_id := fnd_global.resp_id;
1824:
1825: if(p_summary is null) then

Line 1823: l_resp_id := fnd_global.resp_id;

1819:
1820: --get the user id and the party id for the current logged in user.
1821: l_user_id := fnd_global.user_id;
1822: l_party_id := pa_control_items_utils.getpartyid(l_user_id);
1823: l_resp_id := fnd_global.resp_id;
1824:
1825: if(p_summary is null) then
1826: PA_UTILS.ADD_MESSAGE
1827: (p_app_short_name => 'PA',

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

2467: -- initialize the return status to success
2468: x_return_status := fnd_api.g_ret_sts_success;
2469: x_msg_count := 0;
2470:
2471: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.resp_id, 275, null, null), 'N');
2472: l_module_name := 'check_create_action_allow' || g_module_name;
2473:
2474: if l_debug_mode = 'Y' then
2475: pa_debug.set_curr_function(p_function => 'pa_control_api_pvt.check_create_action_allow', p_debug_mode => l_debug_mode);

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

2633: -- initialize the return status to success
2634: x_return_status := fnd_api.g_ret_sts_success;
2635: x_msg_count := 0;
2636:
2637: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.resp_id, 275, null, null), 'N');
2638: l_module_name := 'validate_assignee_id' || g_module_name;
2639:
2640: if l_debug_mode = 'Y' then
2641: pa_debug.set_curr_function(p_function => 'pa_control_api_pvt.validate_assignee_id', p_debug_mode => l_debug_mode);

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

2804: -- initialize the return status to success
2805: x_return_status := fnd_api.g_ret_sts_success;
2806: x_msg_count := 0;
2807:
2808: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.resp_id, 275, null, null), 'N');
2809: l_module_name := 'validate_action_attributes' || g_module_name;
2810:
2811: if l_debug_mode = 'Y' then
2812: pa_debug.set_curr_function(p_function => 'pa_control_api_pvt.validate_action_attributes', p_debug_mode => l_debug_mode);

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

3126: -- initialize the return status to success
3127: x_return_status := fnd_api.g_ret_sts_success;
3128: x_msg_count := 0;
3129:
3130: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.resp_id, 275, null, null), 'N');
3131: l_module_name := 'create_action' || g_module_name;
3132:
3133: if l_debug_mode = 'Y' then
3134: pa_debug.set_curr_function(p_function => 'pa_control_api_pvt.create_action', p_debug_mode => l_debug_mode);

Line 3179: p_last_updated_by => fnd_global.user_id,

3175: p_sign_off_required_flag => p_action_tbl(i).sign_off_requested_flag,
3176: p_date_closed => p_action_tbl(i).closed_date,
3177: p_sign_off_flag => p_action_tbl(i).signed_off,
3178: p_source_ci_action_id => p_action_tbl(i).source_ci_action_id,
3179: p_last_updated_by => fnd_global.user_id,
3180: p_created_by => fnd_global.user_id,
3181: p_creation_date => sysdate,
3182: p_last_update_date => sysdate,
3183: p_last_update_login => fnd_global.login_id, --this shd not be user_id.

Line 3180: p_created_by => fnd_global.user_id,

3176: p_date_closed => p_action_tbl(i).closed_date,
3177: p_sign_off_flag => p_action_tbl(i).signed_off,
3178: p_source_ci_action_id => p_action_tbl(i).source_ci_action_id,
3179: p_last_updated_by => fnd_global.user_id,
3180: p_created_by => fnd_global.user_id,
3181: p_creation_date => sysdate,
3182: p_last_update_date => sysdate,
3183: p_last_update_login => fnd_global.login_id, --this shd not be user_id.
3184: p_record_version_number => 1);

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

3179: p_last_updated_by => fnd_global.user_id,
3180: p_created_by => fnd_global.user_id,
3181: p_creation_date => sysdate,
3182: p_last_update_date => sysdate,
3183: p_last_update_login => fnd_global.login_id, --this shd not be user_id.
3184: p_record_version_number => 1);
3185:
3186: /* now prepare the output table to store the output values*/
3187: x_action_tbl(i).action_id := l_ci_action_id;

Line 3208: p_last_updated_by => fnd_global.user_id,

3204: p_ci_comment_id => l_ci_comment_id,
3205: p_ci_id => p_ci_id,
3206: p_type_code => l_type_code,
3207: p_comment_text => p_action_tbl(i).request_text,
3208: p_last_updated_by => fnd_global.user_id,
3209: p_created_by => fnd_global.user_id,
3210: p_creation_date => sysdate,
3211: p_last_update_date => sysdate,
3212: p_last_update_login => fnd_global.login_id, --this shd not be user_id

Line 3209: p_created_by => fnd_global.user_id,

3205: p_ci_id => p_ci_id,
3206: p_type_code => l_type_code,
3207: p_comment_text => p_action_tbl(i).request_text,
3208: p_last_updated_by => fnd_global.user_id,
3209: p_created_by => fnd_global.user_id,
3210: p_creation_date => sysdate,
3211: p_last_update_date => sysdate,
3212: p_last_update_login => fnd_global.login_id, --this shd not be user_id
3213: p_ci_action_id => l_ci_action_id);

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

3208: p_last_updated_by => fnd_global.user_id,
3209: p_created_by => fnd_global.user_id,
3210: p_creation_date => sysdate,
3211: p_last_update_date => sysdate,
3212: p_last_update_login => fnd_global.login_id, --this shd not be user_id
3213: p_ci_action_id => l_ci_action_id);
3214:
3215:
3216: if l_debug_mode = 'Y' then

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

3385: -- initialize the return status to success
3386: x_return_status := fnd_api.g_ret_sts_success;
3387: x_msg_count := 0;
3388:
3389: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.resp_id, 275, null, null), 'N');
3390: l_module_name := 'validate_priv_and_action' || g_module_name;
3391:
3392: if l_debug_mode = 'Y' then
3393: pa_debug.set_curr_function(p_function => 'pa_control_api_pub.validate_priv_and_action', p_debug_mode => l_debug_mode);

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

3561: l_Msg_Index_Out NUMBER;
3562: l_CiId PA_CONTROL_ITEMS.Ci_Id%TYPE;
3563: -- End: Local Variables.
3564: BEGIN
3565: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.resp_id, 275, null, null), 'N');
3566: l_module_name := 'Delete_CI' || g_module_name;
3567:
3568: if l_debug_mode = 'Y' then
3569: pa_debug.set_curr_function(p_function => 'pa_control_api_pub.Delete_CI', p_debug_mode => l_debug_mode);