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.AS_SALES_LEAD_ENGINE_PVT dependencies on FND_GLOBAL

Line 229: IF FND_GLOBAL.User_Id IS NULL

225:
226: -- Initialize build sales team flag to 'N'
227: x_lead_engines_out_rec.sales_team_flag := 'N';
228:
229: IF FND_GLOBAL.User_Id IS NULL
230: THEN
231: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
232: THEN
233: AS_UTILITY_PVT.Set_Message(

Line 391: p_created_by => fnd_global.user_id,

387:
388: AS_SALES_LEADS_LOG_PKG.Insert_Row(
389: px_log_id => l_sales_lead_log_id ,
390: p_sales_lead_id => p_sales_lead_id,
391: p_created_by => fnd_global.user_id,
392: p_creation_date => SYSDATE,
393: p_last_updated_by => fnd_global.user_id,
394: p_last_update_date => SYSDATE,
395: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,

Line 393: p_last_updated_by => fnd_global.user_id,

389: px_log_id => l_sales_lead_log_id ,
390: p_sales_lead_id => p_sales_lead_id,
391: p_created_by => fnd_global.user_id,
392: p_creation_date => SYSDATE,
393: p_last_updated_by => fnd_global.user_id,
394: p_last_update_date => SYSDATE,
395: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
396: p_request_id =>
397: FND_GLOBAL.Conc_Request_Id,

Line 395: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,

391: p_created_by => fnd_global.user_id,
392: p_creation_date => SYSDATE,
393: p_last_updated_by => fnd_global.user_id,
394: p_last_update_date => SYSDATE,
395: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
396: p_request_id =>
397: FND_GLOBAL.Conc_Request_Id,
398: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,
399: p_program_id =>

Line 397: FND_GLOBAL.Conc_Request_Id,

393: p_last_updated_by => fnd_global.user_id,
394: p_last_update_date => SYSDATE,
395: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
396: p_request_id =>
397: FND_GLOBAL.Conc_Request_Id,
398: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,
399: p_program_id =>
400: FND_GLOBAL.Conc_Program_Id,
401: p_program_update_date => SYSDATE,

Line 398: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,

394: p_last_update_date => SYSDATE,
395: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
396: p_request_id =>
397: FND_GLOBAL.Conc_Request_Id,
398: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,
399: p_program_id =>
400: FND_GLOBAL.Conc_Program_Id,
401: p_program_update_date => SYSDATE,
402: p_status_code => l_sales_lead_rec.status_code,

Line 400: FND_GLOBAL.Conc_Program_Id,

396: p_request_id =>
397: FND_GLOBAL.Conc_Request_Id,
398: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,
399: p_program_id =>
400: FND_GLOBAL.Conc_Program_Id,
401: p_program_update_date => SYSDATE,
402: p_status_code => l_sales_lead_rec.status_code,
403: p_assign_to_person_id => l_sales_lead_rec.assign_to_person_id,
404: p_assign_to_salesforce_id => l_sales_lead_rec.assign_to_salesforce_id,

Line 1258: IF FND_GLOBAL.User_Id IS NULL

1254: -- ******************************************************************
1255: -- Validate Environment
1256: -- ******************************************************************
1257:
1258: IF FND_GLOBAL.User_Id IS NULL
1259: THEN
1260: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1261: THEN
1262: AS_UTILITY_PVT.Set_Message(

Line 1690: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID

1686: PV_ENTITY_RULES_APPLIED_PKG.Insert_Row(
1687: px_ENTITY_RULE_APPLIED_ID =>
1688: l_entity_rule_applied_id
1689: ,p_LAST_UPDATE_DATE => SYSDATE
1690: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
1691: ,p_CREATION_DATE => SYSDATE
1692: ,p_CREATED_BY => FND_GLOBAL.USER_ID
1693: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
1694: ,p_OBJECT_VERSION_NUMBER => 1

Line 1692: ,p_CREATED_BY => FND_GLOBAL.USER_ID

1688: l_entity_rule_applied_id
1689: ,p_LAST_UPDATE_DATE => SYSDATE
1690: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
1691: ,p_CREATION_DATE => SYSDATE
1692: ,p_CREATED_BY => FND_GLOBAL.USER_ID
1693: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
1694: ,p_OBJECT_VERSION_NUMBER => 1
1695: ,p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id
1696: ,p_PROGRAM_APPLICATION_ID =>

Line 1693: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID

1689: ,p_LAST_UPDATE_DATE => SYSDATE
1690: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
1691: ,p_CREATION_DATE => SYSDATE
1692: ,p_CREATED_BY => FND_GLOBAL.USER_ID
1693: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
1694: ,p_OBJECT_VERSION_NUMBER => 1
1695: ,p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id
1696: ,p_PROGRAM_APPLICATION_ID =>
1697: FND_GLOBAL.Prog_Appl_Id

Line 1695: ,p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id

1691: ,p_CREATION_DATE => SYSDATE
1692: ,p_CREATED_BY => FND_GLOBAL.USER_ID
1693: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
1694: ,p_OBJECT_VERSION_NUMBER => 1
1695: ,p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id
1696: ,p_PROGRAM_APPLICATION_ID =>
1697: FND_GLOBAL.Prog_Appl_Id
1698: ,p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id
1699: ,p_PROGRAM_UPDATE_DATE => SYSDATE

Line 1697: FND_GLOBAL.Prog_Appl_Id

1693: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
1694: ,p_OBJECT_VERSION_NUMBER => 1
1695: ,p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id
1696: ,p_PROGRAM_APPLICATION_ID =>
1697: FND_GLOBAL.Prog_Appl_Id
1698: ,p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id
1699: ,p_PROGRAM_UPDATE_DATE => SYSDATE
1700: ,p_ENTITY => 'SALES_LEAD'
1701: ,p_ENTITY_ID => p_sales_lead_id

Line 1698: ,p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id

1694: ,p_OBJECT_VERSION_NUMBER => 1
1695: ,p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id
1696: ,p_PROGRAM_APPLICATION_ID =>
1697: FND_GLOBAL.Prog_Appl_Id
1698: ,p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id
1699: ,p_PROGRAM_UPDATE_DATE => SYSDATE
1700: ,p_ENTITY => 'SALES_LEAD'
1701: ,p_ENTITY_ID => p_sales_lead_id
1702: ,p_PROCESS_RULE_ID =>

Line 1745: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID

1741: PV_ENTITY_RULES_APPLIED_PKG.Insert_Row(
1742: px_ENTITY_RULE_APPLIED_ID =>
1743: l_entity_rule_applied_id
1744: ,p_LAST_UPDATE_DATE => SYSDATE
1745: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
1746: ,p_CREATION_DATE => SYSDATE
1747: ,p_CREATED_BY => FND_GLOBAL.USER_ID
1748: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
1749: ,p_OBJECT_VERSION_NUMBER => 1

Line 1747: ,p_CREATED_BY => FND_GLOBAL.USER_ID

1743: l_entity_rule_applied_id
1744: ,p_LAST_UPDATE_DATE => SYSDATE
1745: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
1746: ,p_CREATION_DATE => SYSDATE
1747: ,p_CREATED_BY => FND_GLOBAL.USER_ID
1748: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
1749: ,p_OBJECT_VERSION_NUMBER => 1
1750: ,p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id
1751: ,p_PROGRAM_APPLICATION_ID =>

Line 1748: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID

1744: ,p_LAST_UPDATE_DATE => SYSDATE
1745: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
1746: ,p_CREATION_DATE => SYSDATE
1747: ,p_CREATED_BY => FND_GLOBAL.USER_ID
1748: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
1749: ,p_OBJECT_VERSION_NUMBER => 1
1750: ,p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id
1751: ,p_PROGRAM_APPLICATION_ID =>
1752: FND_GLOBAL.Prog_Appl_Id

Line 1750: ,p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id

1746: ,p_CREATION_DATE => SYSDATE
1747: ,p_CREATED_BY => FND_GLOBAL.USER_ID
1748: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
1749: ,p_OBJECT_VERSION_NUMBER => 1
1750: ,p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id
1751: ,p_PROGRAM_APPLICATION_ID =>
1752: FND_GLOBAL.Prog_Appl_Id
1753: ,p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id
1754: ,p_PROGRAM_UPDATE_DATE => SYSDATE

Line 1752: FND_GLOBAL.Prog_Appl_Id

1748: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
1749: ,p_OBJECT_VERSION_NUMBER => 1
1750: ,p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id
1751: ,p_PROGRAM_APPLICATION_ID =>
1752: FND_GLOBAL.Prog_Appl_Id
1753: ,p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id
1754: ,p_PROGRAM_UPDATE_DATE => SYSDATE
1755: ,p_ENTITY => 'SALES_LEAD'
1756: ,p_ENTITY_ID => p_sales_lead_id

Line 1753: ,p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id

1749: ,p_OBJECT_VERSION_NUMBER => 1
1750: ,p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id
1751: ,p_PROGRAM_APPLICATION_ID =>
1752: FND_GLOBAL.Prog_Appl_Id
1753: ,p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id
1754: ,p_PROGRAM_UPDATE_DATE => SYSDATE
1755: ,p_ENTITY => 'SALES_LEAD'
1756: ,p_ENTITY_ID => p_sales_lead_id
1757: ,p_PROCESS_RULE_ID =>

Line 1800: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID

1796: l_entity_rule_applied_id := NULL;
1797: PV_ENTITY_RULES_APPLIED_PKG.Insert_Row(
1798: px_ENTITY_RULE_APPLIED_ID => l_entity_rule_applied_id
1799: ,p_LAST_UPDATE_DATE => SYSDATE
1800: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
1801: ,p_CREATION_DATE => SYSDATE
1802: ,p_CREATED_BY => FND_GLOBAL.USER_ID
1803: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
1804: ,p_OBJECT_VERSION_NUMBER => 1

Line 1802: ,p_CREATED_BY => FND_GLOBAL.USER_ID

1798: px_ENTITY_RULE_APPLIED_ID => l_entity_rule_applied_id
1799: ,p_LAST_UPDATE_DATE => SYSDATE
1800: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
1801: ,p_CREATION_DATE => SYSDATE
1802: ,p_CREATED_BY => FND_GLOBAL.USER_ID
1803: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
1804: ,p_OBJECT_VERSION_NUMBER => 1
1805: ,p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id
1806: ,p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id

Line 1803: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID

1799: ,p_LAST_UPDATE_DATE => SYSDATE
1800: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
1801: ,p_CREATION_DATE => SYSDATE
1802: ,p_CREATED_BY => FND_GLOBAL.USER_ID
1803: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
1804: ,p_OBJECT_VERSION_NUMBER => 1
1805: ,p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id
1806: ,p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id
1807: ,p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id

Line 1805: ,p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id

1801: ,p_CREATION_DATE => SYSDATE
1802: ,p_CREATED_BY => FND_GLOBAL.USER_ID
1803: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
1804: ,p_OBJECT_VERSION_NUMBER => 1
1805: ,p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id
1806: ,p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id
1807: ,p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id
1808: ,p_PROGRAM_UPDATE_DATE => SYSDATE
1809: ,p_ENTITY => 'SALES_LEAD'

Line 1806: ,p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id

1802: ,p_CREATED_BY => FND_GLOBAL.USER_ID
1803: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
1804: ,p_OBJECT_VERSION_NUMBER => 1
1805: ,p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id
1806: ,p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id
1807: ,p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id
1808: ,p_PROGRAM_UPDATE_DATE => SYSDATE
1809: ,p_ENTITY => 'SALES_LEAD'
1810: ,p_ENTITY_ID => p_sales_lead_id

Line 1807: ,p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id

1803: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
1804: ,p_OBJECT_VERSION_NUMBER => 1
1805: ,p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id
1806: ,p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id
1807: ,p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id
1808: ,p_PROGRAM_UPDATE_DATE => SYSDATE
1809: ,p_ENTITY => 'SALES_LEAD'
1810: ,p_ENTITY_ID => p_sales_lead_id
1811: ,p_PROCESS_RULE_ID => NULL

Line 2053: ,p_LAST_UPDATED_BY => fnd_global.user_id

2049:
2050: AML_RULE_APPLIED_ATTRS_PKG.Insert_Row(
2051: px_RULE_APPLIED_ATTR_ID => l_rule_applied_attrs_id
2052: ,p_LAST_UPDATE_DATE => SYSDATE
2053: ,p_LAST_UPDATED_BY => fnd_global.user_id
2054: ,p_CREATION_DATE => SYSDATE
2055: ,p_CREATED_BY => fnd_global.user_id
2056: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
2057: ,p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM

Line 2055: ,p_CREATED_BY => fnd_global.user_id

2051: px_RULE_APPLIED_ATTR_ID => l_rule_applied_attrs_id
2052: ,p_LAST_UPDATE_DATE => SYSDATE
2053: ,p_LAST_UPDATED_BY => fnd_global.user_id
2054: ,p_CREATION_DATE => SYSDATE
2055: ,p_CREATED_BY => fnd_global.user_id
2056: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
2057: ,p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
2058: ,p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id
2059: ,p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id

Line 2056: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID

2052: ,p_LAST_UPDATE_DATE => SYSDATE
2053: ,p_LAST_UPDATED_BY => fnd_global.user_id
2054: ,p_CREATION_DATE => SYSDATE
2055: ,p_CREATED_BY => fnd_global.user_id
2056: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
2057: ,p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
2058: ,p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id
2059: ,p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id
2060: ,p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id

Line 2058: ,p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id

2054: ,p_CREATION_DATE => SYSDATE
2055: ,p_CREATED_BY => fnd_global.user_id
2056: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
2057: ,p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
2058: ,p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id
2059: ,p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id
2060: ,p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id
2061: ,p_PROGRAM_UPDATE_DATE => SYSDATE
2062: ,p_ENTITY_RULE_APPLIED_ID => l_winning_rule_ent_rule_app_id

Line 2059: ,p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id

2055: ,p_CREATED_BY => fnd_global.user_id
2056: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
2057: ,p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
2058: ,p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id
2059: ,p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id
2060: ,p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id
2061: ,p_PROGRAM_UPDATE_DATE => SYSDATE
2062: ,p_ENTITY_RULE_APPLIED_ID => l_winning_rule_ent_rule_app_id
2063: ,p_ATTRIBUTE_ID => l_enty_select_criteria_val.attribute_id

Line 2060: ,p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id

2056: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
2057: ,p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
2058: ,p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id
2059: ,p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id
2060: ,p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id
2061: ,p_PROGRAM_UPDATE_DATE => SYSDATE
2062: ,p_ENTITY_RULE_APPLIED_ID => l_winning_rule_ent_rule_app_id
2063: ,p_ATTRIBUTE_ID => l_enty_select_criteria_val.attribute_id
2064: ,p_OPERATOR => l_enty_select_criteria_val.operator

Line 2100: p_created_by => fnd_global.user_id,

2096: THEN
2097: AS_SALES_LEADS_LOG_PKG.Insert_Row(
2098: px_log_id => l_sales_lead_log_id ,
2099: p_sales_lead_id => p_sales_lead_id,
2100: p_created_by => fnd_global.user_id,
2101: p_creation_date => SYSDATE,
2102: p_last_updated_by => fnd_global.user_id,
2103: p_last_update_date => SYSDATE,
2104: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,

Line 2102: p_last_updated_by => fnd_global.user_id,

2098: px_log_id => l_sales_lead_log_id ,
2099: p_sales_lead_id => p_sales_lead_id,
2100: p_created_by => fnd_global.user_id,
2101: p_creation_date => SYSDATE,
2102: p_last_updated_by => fnd_global.user_id,
2103: p_last_update_date => SYSDATE,
2104: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
2105: p_request_id =>
2106: FND_GLOBAL.Conc_Request_Id,

Line 2104: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,

2100: p_created_by => fnd_global.user_id,
2101: p_creation_date => SYSDATE,
2102: p_last_updated_by => fnd_global.user_id,
2103: p_last_update_date => SYSDATE,
2104: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
2105: p_request_id =>
2106: FND_GLOBAL.Conc_Request_Id,
2107: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,
2108: p_program_id =>

Line 2106: FND_GLOBAL.Conc_Request_Id,

2102: p_last_updated_by => fnd_global.user_id,
2103: p_last_update_date => SYSDATE,
2104: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
2105: p_request_id =>
2106: FND_GLOBAL.Conc_Request_Id,
2107: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,
2108: p_program_id =>
2109: FND_GLOBAL.Conc_Program_Id,
2110: p_program_update_date => SYSDATE,

Line 2107: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,

2103: p_last_update_date => SYSDATE,
2104: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
2105: p_request_id =>
2106: FND_GLOBAL.Conc_Request_Id,
2107: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,
2108: p_program_id =>
2109: FND_GLOBAL.Conc_Program_Id,
2110: p_program_update_date => SYSDATE,
2111: p_status_code => l_status_code,

Line 2109: FND_GLOBAL.Conc_Program_Id,

2105: p_request_id =>
2106: FND_GLOBAL.Conc_Request_Id,
2107: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,
2108: p_program_id =>
2109: FND_GLOBAL.Conc_Program_Id,
2110: p_program_update_date => SYSDATE,
2111: p_status_code => l_status_code,
2112: p_assign_to_person_id => l_assign_to_person_id,
2113: p_assign_to_salesforce_id => l_assign_to_salesforce_id,

Line 2132: p_created_by => fnd_global.user_id,

2128:
2129: AS_SALES_LEADS_LOG_PKG.Insert_Row(
2130: px_log_id => l_sales_lead_log_id ,
2131: p_sales_lead_id => p_sales_lead_id,
2132: p_created_by => fnd_global.user_id,
2133: p_creation_date => SYSDATE,
2134: p_last_updated_by => fnd_global.user_id,
2135: p_last_update_date => SYSDATE,
2136: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,

Line 2134: p_last_updated_by => fnd_global.user_id,

2130: px_log_id => l_sales_lead_log_id ,
2131: p_sales_lead_id => p_sales_lead_id,
2132: p_created_by => fnd_global.user_id,
2133: p_creation_date => SYSDATE,
2134: p_last_updated_by => fnd_global.user_id,
2135: p_last_update_date => SYSDATE,
2136: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
2137: p_request_id =>
2138: FND_GLOBAL.Conc_Request_Id,

Line 2136: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,

2132: p_created_by => fnd_global.user_id,
2133: p_creation_date => SYSDATE,
2134: p_last_updated_by => fnd_global.user_id,
2135: p_last_update_date => SYSDATE,
2136: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
2137: p_request_id =>
2138: FND_GLOBAL.Conc_Request_Id,
2139: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,
2140: p_program_id =>

Line 2138: FND_GLOBAL.Conc_Request_Id,

2134: p_last_updated_by => fnd_global.user_id,
2135: p_last_update_date => SYSDATE,
2136: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
2137: p_request_id =>
2138: FND_GLOBAL.Conc_Request_Id,
2139: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,
2140: p_program_id =>
2141: FND_GLOBAL.Conc_Program_Id,
2142: p_program_update_date => SYSDATE,

Line 2139: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,

2135: p_last_update_date => SYSDATE,
2136: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
2137: p_request_id =>
2138: FND_GLOBAL.Conc_Request_Id,
2139: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,
2140: p_program_id =>
2141: FND_GLOBAL.Conc_Program_Id,
2142: p_program_update_date => SYSDATE,
2143: p_status_code => l_status_code,

Line 2141: FND_GLOBAL.Conc_Program_Id,

2137: p_request_id =>
2138: FND_GLOBAL.Conc_Request_Id,
2139: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,
2140: p_program_id =>
2141: FND_GLOBAL.Conc_Program_Id,
2142: p_program_update_date => SYSDATE,
2143: p_status_code => l_status_code,
2144: p_assign_to_person_id => l_assign_to_person_id,
2145: p_assign_to_salesforce_id => l_assign_to_salesforce_id,

Line 2210: p_created_by => fnd_global.user_id,

2206:
2207: AS_SALES_LEADS_LOG_PKG.Insert_Row(
2208: px_log_id => l_sales_lead_log_id ,
2209: p_sales_lead_id => p_sales_lead_id,
2210: p_created_by => fnd_global.user_id,
2211: p_creation_date => SYSDATE,
2212: p_last_updated_by => fnd_global.user_id,
2213: p_last_update_date => SYSDATE,
2214: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,

Line 2212: p_last_updated_by => fnd_global.user_id,

2208: px_log_id => l_sales_lead_log_id ,
2209: p_sales_lead_id => p_sales_lead_id,
2210: p_created_by => fnd_global.user_id,
2211: p_creation_date => SYSDATE,
2212: p_last_updated_by => fnd_global.user_id,
2213: p_last_update_date => SYSDATE,
2214: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
2215: p_request_id =>
2216: FND_GLOBAL.Conc_Request_Id,

Line 2214: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,

2210: p_created_by => fnd_global.user_id,
2211: p_creation_date => SYSDATE,
2212: p_last_updated_by => fnd_global.user_id,
2213: p_last_update_date => SYSDATE,
2214: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
2215: p_request_id =>
2216: FND_GLOBAL.Conc_Request_Id,
2217: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,
2218: p_program_id =>

Line 2216: FND_GLOBAL.Conc_Request_Id,

2212: p_last_updated_by => fnd_global.user_id,
2213: p_last_update_date => SYSDATE,
2214: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
2215: p_request_id =>
2216: FND_GLOBAL.Conc_Request_Id,
2217: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,
2218: p_program_id =>
2219: FND_GLOBAL.Conc_Program_Id,
2220: p_program_update_date => SYSDATE,

Line 2217: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,

2213: p_last_update_date => SYSDATE,
2214: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
2215: p_request_id =>
2216: FND_GLOBAL.Conc_Request_Id,
2217: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,
2218: p_program_id =>
2219: FND_GLOBAL.Conc_Program_Id,
2220: p_program_update_date => SYSDATE,
2221: p_status_code => l_status_code,

Line 2219: FND_GLOBAL.Conc_Program_Id,

2215: p_request_id =>
2216: FND_GLOBAL.Conc_Request_Id,
2217: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,
2218: p_program_id =>
2219: FND_GLOBAL.Conc_Program_Id,
2220: p_program_update_date => SYSDATE,
2221: p_status_code => l_status_code,
2222: p_assign_to_person_id => l_assign_to_person_id,
2223: p_assign_to_salesforce_id => l_assign_to_salesforce_id,

Line 2289: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID

2285: l_entity_rule_applied_id := NULL;
2286: PV_ENTITY_RULES_APPLIED_PKG.Insert_Row(
2287: px_ENTITY_RULE_APPLIED_ID => l_entity_rule_applied_id
2288: ,p_LAST_UPDATE_DATE => SYSDATE
2289: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
2290: ,p_CREATION_DATE => SYSDATE
2291: ,p_CREATED_BY => FND_GLOBAL.USER_ID
2292: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
2293: ,p_OBJECT_VERSION_NUMBER => 1

Line 2291: ,p_CREATED_BY => FND_GLOBAL.USER_ID

2287: px_ENTITY_RULE_APPLIED_ID => l_entity_rule_applied_id
2288: ,p_LAST_UPDATE_DATE => SYSDATE
2289: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
2290: ,p_CREATION_DATE => SYSDATE
2291: ,p_CREATED_BY => FND_GLOBAL.USER_ID
2292: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
2293: ,p_OBJECT_VERSION_NUMBER => 1
2294: ,p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id
2295: ,p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id

Line 2292: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID

2288: ,p_LAST_UPDATE_DATE => SYSDATE
2289: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
2290: ,p_CREATION_DATE => SYSDATE
2291: ,p_CREATED_BY => FND_GLOBAL.USER_ID
2292: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
2293: ,p_OBJECT_VERSION_NUMBER => 1
2294: ,p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id
2295: ,p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id
2296: ,p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id

Line 2294: ,p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id

2290: ,p_CREATION_DATE => SYSDATE
2291: ,p_CREATED_BY => FND_GLOBAL.USER_ID
2292: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
2293: ,p_OBJECT_VERSION_NUMBER => 1
2294: ,p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id
2295: ,p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id
2296: ,p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id
2297: ,p_PROGRAM_UPDATE_DATE => SYSDATE
2298: ,p_ENTITY => 'SALES_LEAD'

Line 2295: ,p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id

2291: ,p_CREATED_BY => FND_GLOBAL.USER_ID
2292: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
2293: ,p_OBJECT_VERSION_NUMBER => 1
2294: ,p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id
2295: ,p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id
2296: ,p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id
2297: ,p_PROGRAM_UPDATE_DATE => SYSDATE
2298: ,p_ENTITY => 'SALES_LEAD'
2299: ,p_ENTITY_ID => p_sales_lead_id

Line 2296: ,p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id

2292: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
2293: ,p_OBJECT_VERSION_NUMBER => 1
2294: ,p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id
2295: ,p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id
2296: ,p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id
2297: ,p_PROGRAM_UPDATE_DATE => SYSDATE
2298: ,p_ENTITY => 'SALES_LEAD'
2299: ,p_ENTITY_ID => p_sales_lead_id
2300: ,p_PROCESS_RULE_ID => NULL

Line 2356: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

2352: -- Invoke table handler(Sales_Lead_Update_Row)
2353: AS_SALES_LEADS_PKG.Sales_Lead_Update_Row(
2354: p_SALES_LEAD_ID => p_SALES_LEAD_ID,
2355: p_LAST_UPDATE_DATE => SYSDATE,
2356: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
2357: p_CREATION_DATE => FND_API.G_MISS_DATE,
2358: p_CREATED_BY => FND_API.G_MISS_NUM,
2359: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
2360: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,

Line 2359: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,

2355: p_LAST_UPDATE_DATE => SYSDATE,
2356: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
2357: p_CREATION_DATE => FND_API.G_MISS_DATE,
2358: p_CREATED_BY => FND_API.G_MISS_NUM,
2359: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
2360: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
2361: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
2362: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
2363: p_PROGRAM_UPDATE_DATE => SYSDATE,

Line 2360: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,

2356: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
2357: p_CREATION_DATE => FND_API.G_MISS_DATE,
2358: p_CREATED_BY => FND_API.G_MISS_NUM,
2359: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
2360: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
2361: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
2362: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
2363: p_PROGRAM_UPDATE_DATE => SYSDATE,
2364: p_LEAD_NUMBER => FND_API.G_MISS_CHAR,

Line 2361: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,

2357: p_CREATION_DATE => FND_API.G_MISS_DATE,
2358: p_CREATED_BY => FND_API.G_MISS_NUM,
2359: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
2360: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
2361: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
2362: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
2363: p_PROGRAM_UPDATE_DATE => SYSDATE,
2364: p_LEAD_NUMBER => FND_API.G_MISS_CHAR,
2365: p_STATUS_CODE => FND_API.G_MISS_CHAR,

Line 2362: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,

2358: p_CREATED_BY => FND_API.G_MISS_NUM,
2359: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
2360: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
2361: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
2362: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
2363: p_PROGRAM_UPDATE_DATE => SYSDATE,
2364: p_LEAD_NUMBER => FND_API.G_MISS_CHAR,
2365: p_STATUS_CODE => FND_API.G_MISS_CHAR,
2366: p_CUSTOMER_ID => FND_API.G_MISS_NUM,

Line 2631: IF FND_GLOBAL.User_Id IS NULL

2627: -- ******************************************************************
2628: -- Validate Environment
2629: -- ******************************************************************
2630:
2631: IF FND_GLOBAL.User_Id IS NULL
2632: THEN
2633: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2634: THEN
2635: AS_UTILITY_PVT.Set_Message(

Line 2751: l_Sales_Team_Rec.last_updated_by := FND_GLOBAL.USER_ID;

2747: CLOSE C_Get_Person;
2748:
2749: -- Add creator to sales team
2750: l_Sales_Team_Rec.last_update_date := SYSDATE;
2751: l_Sales_Team_Rec.last_updated_by := FND_GLOBAL.USER_ID;
2752: l_Sales_Team_Rec.creation_date := SYSDATE;
2753: l_Sales_Team_Rec.created_by := FND_GLOBAL.USER_ID;
2754: l_Sales_Team_Rec.last_update_login := FND_GLOBAL.CONC_LOGIN_ID;
2755: l_Sales_Team_Rec.customer_id := l_Customer_Id;

Line 2753: l_Sales_Team_Rec.created_by := FND_GLOBAL.USER_ID;

2749: -- Add creator to sales team
2750: l_Sales_Team_Rec.last_update_date := SYSDATE;
2751: l_Sales_Team_Rec.last_updated_by := FND_GLOBAL.USER_ID;
2752: l_Sales_Team_Rec.creation_date := SYSDATE;
2753: l_Sales_Team_Rec.created_by := FND_GLOBAL.USER_ID;
2754: l_Sales_Team_Rec.last_update_login := FND_GLOBAL.CONC_LOGIN_ID;
2755: l_Sales_Team_Rec.customer_id := l_Customer_Id;
2756: l_Sales_Team_Rec.address_id := l_Address_Id;
2757: l_Sales_Team_Rec.salesforce_id := P_identity_salesforce_id;

Line 2754: l_Sales_Team_Rec.last_update_login := FND_GLOBAL.CONC_LOGIN_ID;

2750: l_Sales_Team_Rec.last_update_date := SYSDATE;
2751: l_Sales_Team_Rec.last_updated_by := FND_GLOBAL.USER_ID;
2752: l_Sales_Team_Rec.creation_date := SYSDATE;
2753: l_Sales_Team_Rec.created_by := FND_GLOBAL.USER_ID;
2754: l_Sales_Team_Rec.last_update_login := FND_GLOBAL.CONC_LOGIN_ID;
2755: l_Sales_Team_Rec.customer_id := l_Customer_Id;
2756: l_Sales_Team_Rec.address_id := l_Address_Id;
2757: l_Sales_Team_Rec.salesforce_id := P_identity_salesforce_id;
2758: l_Sales_Team_Rec.person_id := l_person_id;

Line 2906: FND_GLOBAL.USER_ID, SYSDATE, FND_GLOBAL.USER_ID,

2902: last_update_login, change_type, delete_flag, insert_flag,
2903: processed_flag)
2904: VALUES
2905: (l_Customer_Id, l_Address_id, P_Sales_Lead_id, SYSDATE,
2906: FND_GLOBAL.USER_ID, SYSDATE, FND_GLOBAL.USER_ID,
2907: FND_GLOBAL.CONC_LOGIN_ID, 'LEAD', 'N', 'Y',
2908: 'Y');
2909: EXCEPTION
2910: WHEN OTHERS THEN

Line 2907: FND_GLOBAL.CONC_LOGIN_ID, 'LEAD', 'N', 'Y',

2903: processed_flag)
2904: VALUES
2905: (l_Customer_Id, l_Address_id, P_Sales_Lead_id, SYSDATE,
2906: FND_GLOBAL.USER_ID, SYSDATE, FND_GLOBAL.USER_ID,
2907: FND_GLOBAL.CONC_LOGIN_ID, 'LEAD', 'N', 'Y',
2908: 'Y');
2909: EXCEPTION
2910: WHEN OTHERS THEN
2911: UPDATE AS_CHANGED_ACCOUNTS_ALL

Line 3136: IF FND_GLOBAL.User_Id IS NULL

3132: -- ******************************************************************
3133: -- Validate Environment
3134: -- ******************************************************************
3135:
3136: IF FND_GLOBAL.User_Id IS NULL
3137: THEN
3138: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3139: THEN
3140: AS_UTILITY_PVT.Set_Message(

Line 3546: FND_GLOBAL.USER_ID, SYSDATE, FND_GLOBAL.USER_ID,

3542: last_update_login, change_type, delete_flag, insert_flag,
3543: processed_flag)
3544: VALUES
3545: (l_Customer_Id, l_Address_id, P_Sales_Lead_id, SYSDATE,
3546: FND_GLOBAL.USER_ID, SYSDATE, FND_GLOBAL.USER_ID,
3547: FND_GLOBAL.CONC_LOGIN_ID, 'LEAD', 'N', 'Y',
3548: 'Y');
3549: EXCEPTION
3550: WHEN OTHERS THEN

Line 3547: FND_GLOBAL.CONC_LOGIN_ID, 'LEAD', 'N', 'Y',

3543: processed_flag)
3544: VALUES
3545: (l_Customer_Id, l_Address_id, P_Sales_Lead_id, SYSDATE,
3546: FND_GLOBAL.USER_ID, SYSDATE, FND_GLOBAL.USER_ID,
3547: FND_GLOBAL.CONC_LOGIN_ID, 'LEAD', 'N', 'Y',
3548: 'Y');
3549: EXCEPTION
3550: WHEN OTHERS THEN
3551: UPDATE AS_CHANGED_ACCOUNTS_ALL