DBA Data[Home] [Help]

APPS.CSP_PARTS_ORDER dependencies on FND_PROFILE

Line 506: fnd_profile.get('RESP_ID',orig_resp_id);

502: -- initialize return status
503: x_return_status := FND_API.G_RET_STS_SUCCESS;
504:
505: l_user_id := nvl(fnd_global.user_id, 0) ;
506: fnd_profile.get('RESP_ID',orig_resp_id);
507: fnd_profile.get('RESP_APPL_ID',orig_resp_appl_id);
508:
509: BEGIN
510: l_org_id := mo_global.get_current_org_id;

Line 507: fnd_profile.get('RESP_APPL_ID',orig_resp_appl_id);

503: x_return_status := FND_API.G_RET_STS_SUCCESS;
504:
505: l_user_id := nvl(fnd_global.user_id, 0) ;
506: fnd_profile.get('RESP_ID',orig_resp_id);
507: fnd_profile.get('RESP_APPL_ID',orig_resp_appl_id);
508:
509: BEGIN
510: l_org_id := mo_global.get_current_org_id;
511:

Line 597: fnd_profile.get('CSP_USER_TEST', new_user);

593: INTO new_user_id,new_resp_id,new_resp_appl_id;
594: CLOSE get_new_context;
595: */
596:
597: fnd_profile.get('CSP_USER_TEST', new_user);
598: new_user_id := substr(new_user, 1, instr(new_user, '~') - 1);
599: new_user := substr(ltrim(new_user, new_user_id), 3);
600: new_resp_id := substr(new_user, 1, instr(new_user, '~') - 1);
601: new_resp_appl_id := substr(ltrim(new_user, new_resp_id), 3);

Line 682: fnd_profile.get('CSP_USER_TEST', new_user);

678: INTO new_user_id,new_resp_id,new_resp_appl_id;
679: CLOSE get_new_context;
680: */
681:
682: fnd_profile.get('CSP_USER_TEST', new_user);
683: new_user_id := substr(new_user, 1, instr(new_user, '~') - 1);
684: new_user := substr(ltrim(new_user, new_user_id), 3);
685: new_resp_id := substr(new_user, 1, instr(new_user, '~') - 1);
686: new_resp_appl_id := substr(ltrim(new_user, new_resp_id), 3);

Line 1621: fnd_profile.get('RESP_ID',orig_resp_id);

1617: -- initialize return status
1618: x_return_status := FND_API.G_RET_STS_SUCCESS;
1619:
1620: l_user_id := nvl(fnd_global.user_id, 0) ;
1621: fnd_profile.get('RESP_ID',orig_resp_id);
1622: fnd_profile.get('RESP_APPL_ID',orig_resp_appl_id);
1623:
1624: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1625: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 1622: fnd_profile.get('RESP_APPL_ID',orig_resp_appl_id);

1618: x_return_status := FND_API.G_RET_STS_SUCCESS;
1619:
1620: l_user_id := nvl(fnd_global.user_id, 0) ;
1621: fnd_profile.get('RESP_ID',orig_resp_id);
1622: fnd_profile.get('RESP_APPL_ID',orig_resp_appl_id);
1623:
1624: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1625: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1626: 'csp.plsql.csp_parts_order.process_order',

Line 1948: FND_PROFILE.GET('CSP_EMPLOYEE_ID', l_employee_id);

1944:
1945: -- bug 12805692
1946: -- if employee_id not found then use CSP_EMPLOYEE_ID profile value
1947: IF l_employee_id is null then
1948: FND_PROFILE.GET('CSP_EMPLOYEE_ID', l_employee_id);
1949: end if;
1950:
1951: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1952: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 3101: FND_PROFILE.GET('CS_INV_VALIDATION_ORG', l_line_tbl(i).source_organization_id); -- taking dummy variable as we are going to throw an error only

3097: FETCH item_desc_cur INTO l_line_tbl(i).item_description;
3098: IF item_Desc_cur%NOTFOUND THEN
3099: CLOSE item_desc_cur;
3100: FND_MESSAGE.SET_NAME ('CSP', 'CSP_INVALID_ITEM_ORGN');
3101: FND_PROFILE.GET('CS_INV_VALIDATION_ORG', l_line_tbl(i).source_organization_id); -- taking dummy variable as we are going to throw an error only
3102:
3103: if l_line_tbl(i).source_organization_id is not null then
3104: SELECT concatenated_segments
3105: INTO l_line_tbl(i).item_description -- taking dummy variable as we are going to throw an error only

Line 3836: fnd_profile.get('CSP_IO_USER', new_user);

3832: FETCH get_new_context
3833: INTO new_user_id,new_resp_id,new_resp_appl_id;
3834: CLOSE get_new_context;
3835: */
3836: fnd_profile.get('CSP_IO_USER', new_user);
3837: new_user_id := substr(new_user, 1, instr(new_user, '~') - 1);
3838: new_user := substr(ltrim(new_user, new_user_id), 3);
3839: new_resp_id := substr(new_user, 1, instr(new_user, '~') - 1);
3840: new_resp_appl_id := substr(ltrim(new_user, new_resp_id), 3);

Line 3856: /* fnd_profile.get('ORG_ID',new_org_id); --Operating Unit for the new context.

3852: new_user_id is not null and
3853: new_resp_appl_id is not null THEN
3854: fnd_global.apps_initialize(new_user_id,new_resp_id,new_resp_appl_id);
3855: mo_global.set_policy_context('S', l_source_operating_unit);
3856: /* fnd_profile.get('ORG_ID',new_org_id); --Operating Unit for the new context.
3857: IF l_source_operating_unit <> new_org_id THEN
3858: FND_MESSAGE.Set_Name('CS','CS_CHG_NEW_CONTEXT_OU_NOT_MATCH'); --to be seeded.
3859: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);
3860: FND_MSG_PUB.Add;

Line 4514: FND_PROFILE.GET('CSP_PO_LINE_TYPE', l_line_Type_id);

4510: po_message_s.sql_error('check_unique','010',sqlcode);
4511: raise;
4512: END;
4513:
4514: FND_PROFILE.GET('CSP_PO_LINE_TYPE', l_line_Type_id);
4515:
4516: FOR I IN 1..l_line_tbl.COUNT LOOP
4517:
4518: -- get requisition_line_id

Line 5228: fnd_profile.get('CSP_CANCEL_REASON', l_cancel_reason);

5224:
5225: -- bug # 12559884
5226: -- put Cancel reason code for cancelling a line
5227: -- value will be picked from the profile CSP_CANCEL_REASON
5228: fnd_profile.get('CSP_CANCEL_REASON', l_cancel_reason);
5229: l_header_can_rec.change_reason := l_cancel_reason;
5230:
5231: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5232: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,