DBA Data[Home] [Help]

APPS.PA_CONTROL_API_PUB dependencies on FND_GLOBAL

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

86: BEGIN
87:
88: x_return_status := FND_API.G_RET_STS_SUCCESS;
89: x_msg_count := 0;
90: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.resp_id, 275, null, null), 'N');
91:
92: IF l_debug_mode = 'Y' THEN
93: PA_DEBUG.set_curr_function(p_function => 'Add_Workplan_Impact', p_debug_mode => l_debug_mode);
94: END IF;

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

218: BEGIN
219:
220: x_return_status := FND_API.G_RET_STS_SUCCESS;
221: x_msg_count := 0;
222: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.resp_id, 275, null, null), 'N');
223:
224: IF l_debug_mode = 'Y' THEN
225: PA_DEBUG.set_curr_function(p_function => 'Add_Staffing_Impact', p_debug_mode => l_debug_mode);
226: END IF;

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

346: BEGIN
347:
348: x_return_status := FND_API.G_RET_STS_SUCCESS;
349: x_msg_count := 0;
350: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.resp_id, 275, null, null), 'N');
351:
352: IF l_debug_mode = 'Y' THEN
353: PA_DEBUG.set_curr_function(p_function => 'Add_Contract_Impact', p_debug_mode => l_debug_mode);
354: END IF;

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

471: BEGIN
472:
473: x_return_status := FND_API.G_RET_STS_SUCCESS;
474: x_msg_count := 0;
475: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.resp_id, 275, null, null), 'N');
476:
477: IF l_debug_mode = 'Y' THEN
478: PA_DEBUG.set_curr_function(p_function => 'Add_Other_Impact', p_debug_mode => l_debug_mode);
479: END IF;

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

612:
613: BEGIN
614: x_return_status := FND_API.G_RET_STS_SUCCESS;
615: x_msg_count := 0;
616: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.resp_id, 275, null, null), 'N');
617:
618: IF l_debug_mode = 'Y' THEN
619: PA_DEBUG.set_curr_function(p_function => 'Add_Supplier_Impact', p_debug_mode => l_debug_mode);
620: END IF;

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

763: BEGIN
764:
765: x_return_status := FND_API.G_RET_STS_SUCCESS;
766: x_msg_count := 0;
767: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.resp_id, 275, null, null), 'N');
768:
769: IF l_debug_mode = 'Y' THEN
770: PA_DEBUG.set_curr_function(p_function => 'Update_Workplan_Impact', p_debug_mode => l_debug_mode);
771: END IF;

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

895: BEGIN
896:
897: x_return_status := FND_API.G_RET_STS_SUCCESS;
898: x_msg_count := 0;
899: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.resp_id, 275, null, null), 'N');
900:
901: IF l_debug_mode = 'Y' THEN
902: PA_DEBUG.set_curr_function(p_function => 'Update_Staffing_Impact', p_debug_mode => l_debug_mode);
903: END IF;

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

1029: BEGIN
1030:
1031: x_return_status := FND_API.G_RET_STS_SUCCESS;
1032: x_msg_count := 0;
1033: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.resp_id, 275, null, null), 'N');
1034:
1035: IF l_debug_mode = 'Y' THEN
1036: PA_DEBUG.set_curr_function(p_function => 'Update_Contract_Impact', p_debug_mode => l_debug_mode);
1037: END IF;

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

1161: BEGIN
1162:
1163: x_return_status := FND_API.G_RET_STS_SUCCESS;
1164: x_msg_count := 0;
1165: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.resp_id, 275, null, null), 'N');
1166:
1167: IF l_debug_mode = 'Y' THEN
1168: PA_DEBUG.set_curr_function(p_function => 'Update_Other_Impact', p_debug_mode => l_debug_mode);
1169: END IF;

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

1292: BEGIN
1293:
1294: x_return_status := FND_API.G_RET_STS_SUCCESS;
1295: x_msg_count := 0;
1296: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.resp_id, 275, null, null), 'N');
1297:
1298: IF l_debug_mode = 'Y' THEN
1299: PA_DEBUG.set_curr_function(p_function => 'Update_Supplier_Impact', p_debug_mode => l_debug_mode);
1300: END IF;

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

1739:
1740:
1741: Begin
1742: x_return_status := FND_API.G_RET_STS_SUCCESS;
1743: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.resp_id, 275, null, null), 'N');
1744: IF l_debug_mode = 'Y' THEN
1745: PA_DEBUG.set_curr_function(p_function => 'UPDATE_PROGRESS', p_debug_mode => l_debug_mode);
1746: END IF;
1747:

Line 2024: l_last_modified_by_id := PA_CONTROL_ITEMS_UTILS.GetPartyId(fnd_global.user_id );

2020: /*end of status_code validation*/
2021:
2022:
2023: --get hz_parties.party_id of the logged in user
2024: l_last_modified_by_id := PA_CONTROL_ITEMS_UTILS.GetPartyId(fnd_global.user_id );
2025:
2026: if p_as_of_date <> G_PA_MISS_DATE and p_as_of_date is not null then
2027: l_as_of_date := p_as_of_date;
2028: else

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

2474: -- initialize the return status to success
2475: x_return_status := fnd_api.g_ret_sts_success;
2476: x_msg_count := 0;
2477:
2478: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.resp_id, 275, null, null), 'N');
2479: l_module_name := 'create_issue' || g_module_name;
2480:
2481: if l_debug_mode = 'Y' then
2482: pa_debug.set_curr_function(p_function => 'pa_control_api_pub.create_issue', 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_change_request' || g_module_name;
3115:
3116: if l_debug_mode = 'Y' then
3117: pa_debug.set_curr_function(p_function => 'pa_control_api_pub.create_change_request', p_debug_mode => l_debug_mode);

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

3744: -- initialize the return status to success
3745: x_return_status := fnd_api.g_ret_sts_success;
3746: x_msg_count := 0;
3747:
3748: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.resp_id, 275, null, null), 'N');
3749: l_module_name := 'create_change_order' || g_module_name;
3750:
3751: if l_debug_mode = 'Y' then
3752: pa_debug.set_curr_function(p_function => 'pa_control_api_pub.create_change_order', p_debug_mode => l_debug_mode);

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

4276: -- initialize the return status to success
4277: x_return_status := fnd_api.g_ret_sts_success;
4278: x_msg_count := 0;
4279:
4280: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.resp_id, 275, null, null), 'N');
4281: l_module_name := 'create_action' || g_module_name;
4282:
4283: if l_debug_mode = 'Y' then
4284: pa_debug.set_curr_function(p_function => 'pa_control_api_pub.create_action', p_debug_mode => l_debug_mode);

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

4498: -- initialize the return status to success
4499: x_return_status := fnd_api.g_ret_sts_success;
4500: x_msg_count := 0;
4501:
4502: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.resp_id, 275, null, null), 'N');
4503: l_module_name := 'take_action' || g_module_name;
4504:
4505: if l_debug_mode = 'Y' then
4506: pa_debug.set_curr_function(p_function => 'pa_control_api_pub.take_action', p_debug_mode => l_debug_mode);

Line 4522: l_user_id := fnd_global.user_id;

4518: pa_debug.write(l_module_name, 'start of take_action', l_debug_level3);
4519: end if;
4520:
4521: --Get the party_id for the logged in user
4522: l_user_id := fnd_global.user_id;
4523: l_party_id := pa_control_items_utils.getpartyid(l_user_id);
4524:
4525: /*Check whether the user has privilige to update this action or not and whether the passed action is valid or not*/
4526: /*for checking the privilege check the party id of the logged in user with party id of person to whom the action is assigned*/

Line 4653: p_last_updated_by => fnd_global.user_id,

4649: p_ci_action_id => l_action_id,
4650: p_sign_off_flag => l_sign_off_flag,
4651: p_record_version_number => get_action_attrs_rec.record_version_number,
4652: p_comment_text => l_response_text,
4653: p_last_updated_by => fnd_global.user_id,
4654: p_last_update_date => sysdate,
4655: p_last_update_login => fnd_global.login_id,
4656: x_return_status => x_return_status,
4657: x_msg_count => x_msg_count,

Line 4655: p_last_update_login => fnd_global.login_id,

4651: p_record_version_number => get_action_attrs_rec.record_version_number,
4652: p_comment_text => l_response_text,
4653: p_last_updated_by => fnd_global.user_id,
4654: p_last_update_date => sysdate,
4655: p_last_update_login => fnd_global.login_id,
4656: x_return_status => x_return_status,
4657: x_msg_count => x_msg_count,
4658: x_msg_data => x_msg_data
4659: );

Line 4795: p_created_by => fnd_global.user_id,

4791: p_assigned_to => l_reassign_to_id,
4792: p_date_required => l_required_by_date,
4793: p_comment_text => l_reassign_request_text,
4794: p_closure_comment => l_response_text,
4795: p_created_by => fnd_global.user_id,
4796: p_creation_date => sysdate,
4797: p_last_updated_by => fnd_global.user_id,
4798: p_last_update_date => sysdate,
4799: p_last_update_login => fnd_global.login_id,

Line 4797: p_last_updated_by => fnd_global.user_id,

4793: p_comment_text => l_reassign_request_text,
4794: p_closure_comment => l_response_text,
4795: p_created_by => fnd_global.user_id,
4796: p_creation_date => sysdate,
4797: p_last_updated_by => fnd_global.user_id,
4798: p_last_update_date => sysdate,
4799: p_last_update_login => fnd_global.login_id,
4800: x_return_status => x_return_status,
4801: x_msg_count => x_msg_count,

Line 4799: p_last_update_login => fnd_global.login_id,

4795: p_created_by => fnd_global.user_id,
4796: p_creation_date => sysdate,
4797: p_last_updated_by => fnd_global.user_id,
4798: p_last_update_date => sysdate,
4799: p_last_update_login => fnd_global.login_id,
4800: x_return_status => x_return_status,
4801: x_msg_count => x_msg_count,
4802: x_msg_data => x_msg_data
4803: );

Line 4861: p_created_by => fnd_global.user_id,

4857: p_ci_id => get_action_attrs_rec.ci_id,
4858: p_type_code => 'UNSOLICITED',
4859: p_comment_text => l_response_text,
4860: p_ci_action_id => l_action_id,
4861: p_created_by => fnd_global.user_id,
4862: p_creation_date => sysdate,
4863: p_last_updated_by => fnd_global.user_id,
4864: p_last_update_date => sysdate,
4865: p_last_update_login => fnd_global.login_id,

Line 4863: p_last_updated_by => fnd_global.user_id,

4859: p_comment_text => l_response_text,
4860: p_ci_action_id => l_action_id,
4861: p_created_by => fnd_global.user_id,
4862: p_creation_date => sysdate,
4863: p_last_updated_by => fnd_global.user_id,
4864: p_last_update_date => sysdate,
4865: p_last_update_login => fnd_global.login_id,
4866: x_return_status => x_return_status,
4867: x_msg_count => x_msg_count,

Line 4865: p_last_update_login => fnd_global.login_id,

4861: p_created_by => fnd_global.user_id,
4862: p_creation_date => sysdate,
4863: p_last_updated_by => fnd_global.user_id,
4864: p_last_update_date => sysdate,
4865: p_last_update_login => fnd_global.login_id,
4866: x_return_status => x_return_status,
4867: x_msg_count => x_msg_count,
4868: x_msg_data => x_msg_data
4869: );

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

5041:
5042: x_return_status := FND_API.G_RET_STS_SUCCESS;
5043: x_msg_count := 0;
5044:
5045: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.resp_id, 275, null, null), 'N');
5046:
5047: IF l_debug_mode = 'Y' THEN
5048: PA_DEBUG.set_curr_function(p_function => 'Cancel_Action', p_debug_mode => l_debug_mode);
5049: END IF;

Line 5064: l_user_id := fnd_global.user_id;

5060: pa_debug.write(l_module_name, 'Start of Cancel_Action', l_debug_level3);
5061: END IF;
5062:
5063: --Get the user_id for the logged in user
5064: l_user_id := fnd_global.user_id;
5065:
5066:
5067: /*Calling the procedure in PA_CONTROL_API_PVT.validate_priv_and_action to validate the
5068: P_ci_id and action_id and action number. and it returns the action_id*/

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

5250: l_Issue VARCHAR2(30) := 'ISSUE';
5251: -- End: Local Variables.
5252: BEGIN
5253:
5254: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.resp_id, 275, null, null), 'N');
5255:
5256: IF l_debug_mode = 'Y' THEN
5257: PA_DEBUG.set_curr_function(p_function => 'Delete_Issue', p_debug_mode => l_debug_mode);
5258: END IF;

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

5402: l_CiTypeClassCode VARCHAR2(30);
5403: l_ChangeRequest VARCHAR2(30) := 'CHANGE_REQUEST';
5404: -- End: Local Variables.
5405: BEGIN
5406: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.resp_id, 275, null, null), 'N');
5407:
5408: IF l_debug_mode = 'Y' THEN
5409: PA_DEBUG.set_curr_function(p_function => 'Delete_Change_Request', p_debug_mode => l_debug_mode);
5410: END IF;

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

5559: l_CiTypeClassCode VARCHAR2(30);
5560: l_ChangeOrder VARCHAR2(30) := 'CHANGE_ORDER';
5561: -- End: Local Variables.
5562: BEGIN
5563: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.resp_id, 275, null, null), 'N');
5564:
5565: IF l_debug_mode = 'Y' THEN
5566: PA_DEBUG.set_curr_function(p_function => 'Delete_Change_Order', p_debug_mode => l_debug_mode);
5567: END IF;

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

5721: l_Msg_Data VARCHAR2(2000);
5722: l_Msg_Index_Out NUMBER;
5723: -- End: Local Variables.
5724: BEGIN
5725: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.resp_id, 275, null, null), 'N');
5726:
5727: IF l_debug_mode = 'Y' THEN
5728: PA_DEBUG.set_curr_function(p_function => 'Add_Comments', p_debug_mode => l_debug_mode);
5729: END IF;

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

5955: l_UpdateAccess VARCHAR2(1);
5956: l_UpdateAllowed VARCHAR2(1);
5957: -- End: Local Variables.
5958: BEGIN
5959: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.resp_id, 275, null, null), 'N');
5960:
5961: IF l_debug_mode = 'Y' THEN
5962: PA_DEBUG.set_curr_function(p_function => 'Add_Related_Items', p_debug_mode => l_debug_mode);
5963: END IF;

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

6261: l_Msg_Data VARCHAR2(2000);
6262: l_Msg_Index_Out NUMBER;
6263: -- End: Local Variables.
6264: BEGIN
6265: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.resp_id, 275, null, null), 'N');
6266:
6267: IF l_debug_mode = 'Y' THEN
6268: PA_DEBUG.set_curr_function(p_function => 'Delete_Related_Item', p_debug_mode => l_debug_mode);
6269: END IF;

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

6770: BEGIN
6771:
6772: x_return_status := FND_API.G_RET_STS_SUCCESS;
6773:
6774: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.login_id, 275, null, null), 'N');
6775:
6776: IF l_debug_mode = 'Y' THEN
6777: PA_DEBUG.set_curr_function(p_function => 'UPDATE_ISSUE', p_debug_mode => l_debug_mode);
6778: END IF;

Line 7104: p_last_updated_by => fnd_global.user_id,

7100: p_ci_comment_id => l_ci_comment_id,
7101: p_ci_id => p_ci_id,
7102: p_type_code => 'CHANGE_OWNER',
7103: p_comment_text => l_comment_text,
7104: p_last_updated_by => fnd_global.user_id,
7105: p_created_by => fnd_global.user_id,
7106: p_creation_date => sysdate,
7107: p_last_update_date => sysdate,
7108: p_last_update_login => fnd_global.login_id,

Line 7105: p_created_by => fnd_global.user_id,

7101: p_ci_id => p_ci_id,
7102: p_type_code => 'CHANGE_OWNER',
7103: p_comment_text => l_comment_text,
7104: p_last_updated_by => fnd_global.user_id,
7105: p_created_by => fnd_global.user_id,
7106: p_creation_date => sysdate,
7107: p_last_update_date => sysdate,
7108: p_last_update_login => fnd_global.login_id,
7109: p_ci_action_id => null);

Line 7108: p_last_update_login => fnd_global.login_id,

7104: p_last_updated_by => fnd_global.user_id,
7105: p_created_by => fnd_global.user_id,
7106: p_creation_date => sysdate,
7107: p_last_update_date => sysdate,
7108: p_last_update_login => fnd_global.login_id,
7109: p_ci_action_id => null);
7110: end if;
7111: end if;
7112: end if;

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

8030: BEGIN
8031:
8032: x_return_status := FND_API.G_RET_STS_SUCCESS;
8033:
8034: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.login_id, 275, null, null), 'N');
8035:
8036: IF l_debug_mode = 'Y' THEN
8037: PA_DEBUG.set_curr_function(p_function => 'UPDATE_CHANGE_REQUEST', p_debug_mode => l_debug_mode);
8038: END IF;

Line 8353: p_last_updated_by => fnd_global.user_id,

8349: p_ci_comment_id => l_ci_comment_id,
8350: p_ci_id => p_ci_id,
8351: p_type_code => 'CHANGE_OWNER',
8352: p_comment_text => l_comment_text,
8353: p_last_updated_by => fnd_global.user_id,
8354: p_created_by => fnd_global.user_id,
8355: p_creation_date => sysdate,
8356: p_last_update_date => sysdate,
8357: p_last_update_login => fnd_global.login_id,

Line 8354: p_created_by => fnd_global.user_id,

8350: p_ci_id => p_ci_id,
8351: p_type_code => 'CHANGE_OWNER',
8352: p_comment_text => l_comment_text,
8353: p_last_updated_by => fnd_global.user_id,
8354: p_created_by => fnd_global.user_id,
8355: p_creation_date => sysdate,
8356: p_last_update_date => sysdate,
8357: p_last_update_login => fnd_global.login_id,
8358: p_ci_action_id => null);

Line 8357: p_last_update_login => fnd_global.login_id,

8353: p_last_updated_by => fnd_global.user_id,
8354: p_created_by => fnd_global.user_id,
8355: p_creation_date => sysdate,
8356: p_last_update_date => sysdate,
8357: p_last_update_login => fnd_global.login_id,
8358: p_ci_action_id => null);
8359: end if;
8360: end if;
8361: end if;

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

9287: BEGIN
9288:
9289: x_return_status := FND_API.G_RET_STS_SUCCESS;
9290:
9291: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.login_id, 275, null, null), 'N');
9292:
9293: IF l_debug_mode = 'Y' THEN
9294: PA_DEBUG.set_curr_function(p_function => 'UPDATE_CHANGE_ORDER', p_debug_mode => l_debug_mode);
9295: END IF;

Line 9610: p_last_updated_by => fnd_global.user_id,

9606: p_ci_comment_id => l_ci_comment_id,
9607: p_ci_id => p_ci_id,
9608: p_type_code => 'CHANGE_OWNER',
9609: p_comment_text => l_comment_text,
9610: p_last_updated_by => fnd_global.user_id,
9611: p_created_by => fnd_global.user_id,
9612: p_creation_date => sysdate,
9613: p_last_update_date => sysdate,
9614: p_last_update_login => fnd_global.login_id,

Line 9611: p_created_by => fnd_global.user_id,

9607: p_ci_id => p_ci_id,
9608: p_type_code => 'CHANGE_OWNER',
9609: p_comment_text => l_comment_text,
9610: p_last_updated_by => fnd_global.user_id,
9611: p_created_by => fnd_global.user_id,
9612: p_creation_date => sysdate,
9613: p_last_update_date => sysdate,
9614: p_last_update_login => fnd_global.login_id,
9615: p_ci_action_id => null);

Line 9614: p_last_update_login => fnd_global.login_id,

9610: p_last_updated_by => fnd_global.user_id,
9611: p_created_by => fnd_global.user_id,
9612: p_creation_date => sysdate,
9613: p_last_update_date => sysdate,
9614: p_last_update_login => fnd_global.login_id,
9615: p_ci_action_id => null);
9616:
9617: end if;
9618: end if;