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_OPP_PVT dependencies on AS_UTILITY_PVT

Line 257: l_validation_mode VARCHAR2(30) := AS_UTILITY_PVT.G_CREATE;

253: l_SALES_LEAD_rec AS_SALES_LEADS_PUB.SALES_LEAD_REC_type;
254: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;
255: l_cnt NUMBER := 0;
256: l_cnt_line NUMBER := 0;
257: l_validation_mode VARCHAR2(30) := AS_UTILITY_PVT.G_CREATE;
258: l_update_access_flag VARCHAR2(1);
259: l_member_role VARCHAR2(5);
260: l_member_access VARCHAR2(5);
261: l_debug BOOLEAN;

Line 286: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'PVT:' || l_api_name || 'start');

282:
283: -- Debug Message
284:
285: IF l_debug THEN
286: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'PVT:' || l_api_name || 'start');
287: END IF;
288:
289: -- Initialize API return status to SUCCESS
290: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 302: AS_UTILITY_PVT.Set_Message(

298: IF FND_GLOBAL.User_Id IS NULL
299: THEN
300: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
301: THEN
302: AS_UTILITY_PVT.Set_Message(
303: p_module => l_module,
304: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
305: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',
306: p_token1 => 'PROFILE',

Line 500: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'PVT: ' || l_api_name || ' End');

496:
497:
498: -- Debug Message
499: IF l_debug THEN
500: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'PVT: ' || l_api_name || ' End');
501: END IF;
502:
503: -- Standard call to get message count and IF count is 1, get message info.
504: FND_MSG_PUB.Count_And_Get

Line 510: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

506: p_data => x_msg_data );
507:
508: EXCEPTION
509: WHEN FND_API.G_EXC_ERROR THEN
510: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
511: P_MODULE => l_module
512: ,P_API_NAME => L_API_NAME
513: ,P_PKG_NAME => G_PKG_NAME
514: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 515: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

511: P_MODULE => l_module
512: ,P_API_NAME => L_API_NAME
513: ,P_PKG_NAME => G_PKG_NAME
514: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
515: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
516: ,X_MSG_COUNT => X_MSG_COUNT
517: ,X_MSG_DATA => X_MSG_DATA
518: ,X_RETURN_STATUS => X_RETURN_STATUS);
519:

Line 521: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

517: ,X_MSG_DATA => X_MSG_DATA
518: ,X_RETURN_STATUS => X_RETURN_STATUS);
519:
520: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
521: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
522: P_MODULE => l_module
523: ,P_API_NAME => L_API_NAME
524: ,P_PKG_NAME => G_PKG_NAME
525: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 526: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

522: P_MODULE => l_module
523: ,P_API_NAME => L_API_NAME
524: ,P_PKG_NAME => G_PKG_NAME
525: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
526: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
527: ,X_MSG_COUNT => X_MSG_COUNT
528: ,X_MSG_DATA => X_MSG_DATA
529: ,X_RETURN_STATUS => X_RETURN_STATUS);
530:

Line 532: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

528: ,X_MSG_DATA => X_MSG_DATA
529: ,X_RETURN_STATUS => X_RETURN_STATUS);
530:
531: WHEN OTHERS THEN
532: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
533: P_MODULE => l_module
534: ,P_API_NAME => L_API_NAME
535: ,P_PKG_NAME => G_PKG_NAME
536: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 536: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

532: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
533: P_MODULE => l_module
534: ,P_API_NAME => L_API_NAME
535: ,P_PKG_NAME => G_PKG_NAME
536: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
537: ,P_SQLCODE => SQLCODE
538: ,P_SQLERRM => SQLERRM
539: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
540: ,X_MSG_COUNT => X_MSG_COUNT

Line 539: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

535: ,P_PKG_NAME => G_PKG_NAME
536: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
537: ,P_SQLCODE => SQLCODE
538: ,P_SQLERRM => SQLERRM
539: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
540: ,X_MSG_COUNT => X_MSG_COUNT
541: ,X_MSG_DATA => X_MSG_DATA
542: ,X_RETURN_STATUS => X_RETURN_STATUS);
543: END Get_Potential_Opportunity;

Line 854: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'PVT:' || l_api_name || ' Start');

850: END IF;
851:
852: -- Debug Message
853: IF l_debug THEN
854: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'PVT:' || l_api_name || ' Start');
855: END IF;
856:
857: -- Initialize API return status to SUCCESS
858: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 871: AS_UTILITY_PVT.Set_Message(

867: IF FND_GLOBAL.User_Id IS NULL
868: THEN
869: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
870: THEN
871: AS_UTILITY_PVT.Set_Message(
872: p_module => l_module,
873: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
874: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',
875: p_token1 => 'PROFILE',

Line 965: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Private API: SALES_LEAD_ID is invalid');

961: ,l_Sales_Lead_Rec.incumbent_partner_resource_id;
962:
963: IF ( C_Get_Sales_Lead%NOTFOUND) THEN
964: IF l_debug THEN
965: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Private API: SALES_LEAD_ID is invalid');
966: END IF;
967:
968: AS_UTILITY_PVT.Set_Message(
969: p_module => l_module,

Line 968: AS_UTILITY_PVT.Set_Message(

964: IF l_debug THEN
965: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Private API: SALES_LEAD_ID is invalid');
966: END IF;
967:
968: AS_UTILITY_PVT.Set_Message(
969: p_module => l_module,
970: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
971: p_msg_name => 'API_INVALID_ID',
972: p_token1 => 'COLUMN',

Line 1056: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Close Cursor C_Get_Opportunity');

1052:
1053: END IF;
1054: -- Debug Message
1055: IF l_debug THEN
1056: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Close Cursor C_Get_Opportunity');
1057: END IF;
1058: Close C_Get_Opportunity;
1059:
1060: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1067: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Calling Validate_sales_lead_id');

1063:
1064: -- Invoke validation procedures
1065: -- Debug message
1066: IF l_debug THEN
1067: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Calling Validate_sales_lead_id');
1068: END IF;
1069:
1070: -- Validate sales lead id whther it is a valid ID.
1071: AS_SALES_LEADS_PVT.Validate_Sales_Lead_Id (

Line 1087: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Validate existing link');

1083:
1084: -- Validate one sales lead can only be link to one opportunity
1085: -- Debug message
1086: IF l_debug THEN
1087: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Validate existing link');
1088: END IF;
1089:
1090: /*
1091: OPEN C_Lead_Link_Exists (P_SALES_LEAD_ID, P_OPPORTUNITY_ID);

Line 1125: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Validate sales lead owner');

1121:
1122: -- Validate if the sales lead owner is the opportunity team leader
1123: -- Debug message
1124: IF l_debug THEN
1125: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Validate sales lead owner');
1126: END IF;
1127:
1128: /*
1129: -- axavier commented this. This check is not required, as the as_sales_leads salesforce_id is not updated

Line 1351: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Copy sales lead contacts data to opp');

1347: -- opportunity contact table
1348:
1349: -- Copy sales lead contacts data to opportunity record contacts
1350: IF l_debug THEN
1351: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Copy sales lead contacts data to opp');
1352: END IF;
1353: l_cnt := 0;
1354: /*
1355: For C_SL_Contacts_Rec In C_Get_Sales_lead_Contacts(P_Sales_Lead_Id) Loop

Line 1411: AS_UTILITY_PVT.Debug_Message(NULL, 'Calling AS_OPP_CONTACT_PVT.Create_Opp_contacts');

1407:
1408: IF l_contact_tbl.count > 0
1409: THEN
1410: IF l_debug THEN
1411: AS_UTILITY_PVT.Debug_Message(NULL, 'Calling AS_OPP_CONTACT_PVT.Create_Opp_contacts');
1412: END IF;
1413:
1414: -- ffang 030503, bug 2826512, call PUB instead of PVT
1415: -- AS_OPP_CONTACT_PVT.Create_opp_contacts (

Line 1534: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'PVT: ' || l_api_name || ' End');

1530:
1531:
1532: -- Debug Message
1533: IF l_debug THEN
1534: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'PVT: ' || l_api_name || ' End');
1535: END IF;
1536:
1537: -- Standard call to get message count and IF count is 1, get message info.
1538: FND_MSG_PUB.Count_And_Get

Line 1544: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1540: p_data => x_msg_data );
1541:
1542: EXCEPTION
1543: WHEN FND_API.G_EXC_ERROR THEN
1544: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1545: P_MODULE => l_module
1546: ,P_API_NAME => L_API_NAME
1547: ,P_PKG_NAME => G_PKG_NAME
1548: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 1549: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

1545: P_MODULE => l_module
1546: ,P_API_NAME => L_API_NAME
1547: ,P_PKG_NAME => G_PKG_NAME
1548: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1549: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1550: ,X_MSG_COUNT => X_MSG_COUNT
1551: ,X_MSG_DATA => X_MSG_DATA
1552: ,X_RETURN_STATUS => X_RETURN_STATUS);
1553:

Line 1555: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1551: ,X_MSG_DATA => X_MSG_DATA
1552: ,X_RETURN_STATUS => X_RETURN_STATUS);
1553:
1554: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1555: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1556: P_MODULE => l_module
1557: ,P_API_NAME => L_API_NAME
1558: ,P_PKG_NAME => G_PKG_NAME
1559: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 1560: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

1556: P_MODULE => l_module
1557: ,P_API_NAME => L_API_NAME
1558: ,P_PKG_NAME => G_PKG_NAME
1559: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1560: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1561: ,X_MSG_COUNT => X_MSG_COUNT
1562: ,X_MSG_DATA => X_MSG_DATA
1563: ,X_RETURN_STATUS => X_RETURN_STATUS);
1564:

Line 1566: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1562: ,X_MSG_DATA => X_MSG_DATA
1563: ,X_RETURN_STATUS => X_RETURN_STATUS);
1564:
1565: WHEN OTHERS THEN
1566: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1567: P_MODULE => l_module
1568: ,P_API_NAME => L_API_NAME
1569: ,P_PKG_NAME => G_PKG_NAME
1570: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 1570: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

1566: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1567: P_MODULE => l_module
1568: ,P_API_NAME => L_API_NAME
1569: ,P_PKG_NAME => G_PKG_NAME
1570: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1571: ,P_SQLCODE => SQLCODE
1572: ,P_SQLERRM => SQLERRM
1573: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1574: ,X_MSG_COUNT => X_MSG_COUNT

Line 1573: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

1569: ,P_PKG_NAME => G_PKG_NAME
1570: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1571: ,P_SQLCODE => SQLCODE
1572: ,P_SQLERRM => SQLERRM
1573: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1574: ,X_MSG_COUNT => X_MSG_COUNT
1575: ,X_MSG_DATA => X_MSG_DATA
1576: ,X_RETURN_STATUS => X_RETURN_STATUS);
1577: END Copy_Lead_To_Opportunity;

Line 1792: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'PVT:' || l_api_name || ' Start');

1788: END IF;
1789:
1790: -- Debug Message
1791: IF l_debug THEN
1792: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'PVT:' || l_api_name || ' Start');
1793: END IF;
1794:
1795: -- Initialize API return status to SUCCESS
1796: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1810: AS_UTILITY_PVT.Set_Message(

1806: IF FND_GLOBAL.User_Id IS NULL
1807: THEN
1808: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1809: THEN
1810: AS_UTILITY_PVT.Set_Message(
1811: p_module => l_module,
1812: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1813: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',
1814: p_token1 => 'PROFILE',

Line 1904: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Private API: SALES_LEAD_ID is invalid');

1900: ,l_Sales_Lead_Rec.incumbent_partner_resource_id;
1901:
1902: IF ( C_Get_Sales_Lead%NOTFOUND) THEN
1903: IF l_debug THEN
1904: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Private API: SALES_LEAD_ID is invalid');
1905: END IF;
1906:
1907: AS_UTILITY_PVT.Set_Message(
1908: p_module => l_module,

Line 1907: AS_UTILITY_PVT.Set_Message(

1903: IF l_debug THEN
1904: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Private API: SALES_LEAD_ID is invalid');
1905: END IF;
1906:
1907: AS_UTILITY_PVT.Set_Message(
1908: p_module => l_module,
1909: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1910: p_msg_name => 'API_INVALID_ID',
1911: p_token1 => 'COLUMN',

Line 1994: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Close Cursor C_Get_Opportunity');

1990:
1991: END IF;
1992: -- Debug Message
1993: IF l_debug THEN
1994: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Close Cursor C_Get_Opportunity');
1995: END IF;
1996: Close C_Get_Opportunity;
1997:
1998: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 2005: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Calling Validate_sales_lead_id');

2001:
2002: -- Invoke validation procedures
2003: -- Debug message
2004: IF l_debug THEN
2005: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Calling Validate_sales_lead_id');
2006: END IF;
2007:
2008: -- Validate sales lead id whther it is a valid ID.
2009: AS_SALES_LEADS_PVT.Validate_Sales_Lead_Id (

Line 2025: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Validate existing link');

2021:
2022: -- Validate one sales lead can only be link to one opportunity
2023: -- Debug message
2024: IF l_debug THEN
2025: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Validate existing link');
2026: END IF;
2027:
2028: OPEN C_Lead_Link_Exists (P_SALES_LEAD_ID , P_OPPORTUNITY_ID);
2029: FETCH C_Lead_Link_Exists into l_val;

Line 2061: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Validate sales lead owner');

2057:
2058: -- Validate if the sales lead owner is the opportunity team leader
2059: -- Debug message
2060: IF l_debug THEN
2061: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Validate sales lead owner');
2062: END IF;
2063: /*
2064: -- axavier commented this. This check is not required, as the as_sales_leads salesforce_id is not updated
2065:

Line 2189: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'PVT: ' || l_api_name || ' End');

2185:
2186:
2187: -- Debug Message
2188: IF l_debug THEN
2189: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'PVT: ' || l_api_name || ' End');
2190: END IF;
2191:
2192: -- Standard call to get message count and IF count is 1, get message info.
2193: FND_MSG_PUB.Count_And_Get

Line 2199: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

2195: p_data => x_msg_data );
2196:
2197: EXCEPTION
2198: WHEN FND_API.G_EXC_ERROR THEN
2199: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2200: P_MODULE => l_module
2201: ,P_API_NAME => L_API_NAME
2202: ,P_PKG_NAME => G_PKG_NAME
2203: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 2204: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

2200: P_MODULE => l_module
2201: ,P_API_NAME => L_API_NAME
2202: ,P_PKG_NAME => G_PKG_NAME
2203: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2204: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
2205: ,X_MSG_COUNT => X_MSG_COUNT
2206: ,X_MSG_DATA => X_MSG_DATA
2207: ,X_RETURN_STATUS => X_RETURN_STATUS);
2208:

Line 2210: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

2206: ,X_MSG_DATA => X_MSG_DATA
2207: ,X_RETURN_STATUS => X_RETURN_STATUS);
2208:
2209: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2210: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2211: P_MODULE => l_module
2212: ,P_API_NAME => L_API_NAME
2213: ,P_PKG_NAME => G_PKG_NAME
2214: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 2215: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

2211: P_MODULE => l_module
2212: ,P_API_NAME => L_API_NAME
2213: ,P_PKG_NAME => G_PKG_NAME
2214: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2215: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
2216: ,X_MSG_COUNT => X_MSG_COUNT
2217: ,X_MSG_DATA => X_MSG_DATA
2218: ,X_RETURN_STATUS => X_RETURN_STATUS);
2219:

Line 2221: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

2217: ,X_MSG_DATA => X_MSG_DATA
2218: ,X_RETURN_STATUS => X_RETURN_STATUS);
2219:
2220: WHEN OTHERS THEN
2221: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2222: P_MODULE => l_module
2223: ,P_API_NAME => L_API_NAME
2224: ,P_PKG_NAME => G_PKG_NAME
2225: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 2225: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

2221: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2222: P_MODULE => l_module
2223: ,P_API_NAME => L_API_NAME
2224: ,P_PKG_NAME => G_PKG_NAME
2225: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
2226: ,P_SQLCODE => SQLCODE
2227: ,P_SQLERRM => SQLERRM
2228: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
2229: ,X_MSG_COUNT => X_MSG_COUNT

Line 2228: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

2224: ,P_PKG_NAME => G_PKG_NAME
2225: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
2226: ,P_SQLCODE => SQLCODE
2227: ,P_SQLERRM => SQLERRM
2228: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
2229: ,X_MSG_COUNT => X_MSG_COUNT
2230: ,X_MSG_DATA => X_MSG_DATA
2231: ,X_RETURN_STATUS => X_RETURN_STATUS);
2232:

Line 2543: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'PVT:' || l_api_name || 'start');

2539: END IF;
2540:
2541: -- Debug Message
2542: IF l_debug THEN
2543: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'PVT:' || l_api_name || 'start');
2544: END IF;
2545:
2546:
2547:

Line 2561: AS_UTILITY_PVT.Set_Message(

2557: IF FND_GLOBAL.User_Id IS NULL
2558: THEN
2559: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2560: THEN
2561: AS_UTILITY_PVT.Set_Message(
2562: p_module => l_module,
2563: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
2564: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',
2565: p_token1 => 'PROFILE',

Line 2591: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Calling Get_Access_Profiles');

2587:
2588: IF(P_Check_Access_Flag = 'Y') THEN
2589: -- Call Get_Access_Profiles to get access_profile_rec
2590: IF l_debug THEN
2591: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Calling Get_Access_Profiles');
2592: END IF;
2593:
2594: AS_SALES_LEADS_PUB.Get_Access_Profiles(
2595: p_profile_tbl => p_sales_lead_profile_tbl,

Line 2599: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Calling Has_updateLeadAccess');

2595: p_profile_tbl => p_sales_lead_profile_tbl,
2596: x_access_profile_rec => l_access_profile_rec);
2597:
2598: IF l_debug THEN
2599: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Calling Has_updateLeadAccess');
2600: END IF;
2601:
2602: AS_ACCESS_PUB.Has_updateLeadAccess(
2603: p_api_version_number => 2.0

Line 2621: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'API_NO_CREATE_PRIVILEGE');

2617: ,x_update_access_flag => l_update_access_flag);
2618:
2619: IF l_update_access_flag <> 'Y' THEN
2620: IF l_debug_err THEN
2621: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'API_NO_CREATE_PRIVILEGE');
2622: END IF;
2623: RAISE FND_API.G_EXC_ERROR;
2624: END IF;
2625:

Line 2635: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Validate existing link');

2631:
2632: -- ffang 020301, validate one sales lead can only create/link one
2633: -- opportunity
2634: IF l_debug THEN
2635: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Validate existing link');
2636: END IF;
2637:
2638: /*
2639: OPEN C_Lead_Link_Exists (P_SALES_LEAD_ID);

Line 2730: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Private API: SALES_LEAD_ID is invalid');

2726:
2727:
2728: IF ( C_Get_Sales_Lead%NOTFOUND) THEN
2729: IF l_debug THEN
2730: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Private API: SALES_LEAD_ID is invalid');
2731: END IF;
2732:
2733: AS_UTILITY_PVT.Set_Message(
2734: p_module => l_module,

Line 2733: AS_UTILITY_PVT.Set_Message(

2729: IF l_debug THEN
2730: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Private API: SALES_LEAD_ID is invalid');
2731: END IF;
2732:
2733: AS_UTILITY_PVT.Set_Message(
2734: p_module => l_module,
2735: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
2736: p_msg_name => 'API_INVALID_ID',
2737: p_token1 => 'COLUMN',

Line 2880: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Calling AS_OPP_HEADER_PVT.Create_opp_header');

2876: l_header_rec.prm_lead_type := l_Sales_Lead_Rec.prm_sales_lead_type;
2877: mo_utils.get_default_ou(l_default_org_id, l_default_ou_name, l_ou_count);
2878: l_header_rec.org_id := l_default_org_id;
2879: IF l_debug THEN
2880: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Calling AS_OPP_HEADER_PVT.Create_opp_header');
2881: END IF;
2882: IF l_debug_high THEN
2883: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'P_Ident_SF_Id : ' || P_Identity_Salesforce_Id);
2884: END IF;

Line 2883: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'P_Ident_SF_Id : ' || P_Identity_Salesforce_Id);

2879: IF l_debug THEN
2880: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Calling AS_OPP_HEADER_PVT.Create_opp_header');
2881: END IF;
2882: IF l_debug_high THEN
2883: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'P_Ident_SF_Id : ' || P_Identity_Salesforce_Id);
2884: END IF;
2885: -- ffang 030503, bug 2826512, call PUB instead of PVT
2886: -- AS_OPP_HEADER_PVT.Create_opp_header (
2887: AS_OPPORTUNITY_PUB.Create_Opp_Header (

Line 2912: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Open Cursor C_Get_Opportunity:' || l_lead_id);

2908: END IF;
2909:
2910:
2911: IF l_debug THEN
2912: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Open Cursor C_Get_Opportunity:' || l_lead_id);
2913: END IF;
2914:
2915: OPEN C_Get_Opportunity(l_lead_id);
2916: FETCH C_Get_Opportunity INTO l_header_rec.last_update_date;

Line 2923: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Copy lines data to opp, sales_lead_id='||P_Sales_Lead_Id);

2919: l_header_rec.lead_id := l_lead_id;
2920:
2921:
2922: IF l_debug THEN
2923: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Copy lines data to opp, sales_lead_id='||P_Sales_Lead_Id);
2924: END IF;
2925:
2926: -- Copy sales lead lines data to opportunity record lines
2927: l_cnt := 0;

Line 2930: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'open lines cursor successfully');

2926: -- Copy sales lead lines data to opportunity record lines
2927: l_cnt := 0;
2928: For C_Sales_Lead_lines_Rec In C_Get_Sales_lead_lines(P_Sales_Lead_Id) Loop
2929: IF l_debug THEN
2930: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'open lines cursor successfully');
2931: END IF;
2932: l_cnt := l_cnt + 1;
2933:
2934: l_sales_lead_line_tbl(l_cnt).sales_lead_line_id

Line 3010: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Calling AS_OPP_LINE_PVT.Create_Opp_Lines');

3006:
3007: if l_line_tbl.count > 0
3008: then
3009: IF l_debug THEN
3010: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Calling AS_OPP_LINE_PVT.Create_Opp_Lines');
3011: END IF;
3012:
3013: -- ffang 030503, bug 2826512, call PUB instead of PVT
3014: -- AS_OPP_line_PVT.Create_opp_lines (

Line 3041: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Calling AS_SALES_LEAD_OPP_PKG.Lead_Opp_Lines_Insert_Row' ||

3037: END IF;
3038:
3039: For l_index In 1..l_line_out_tbl.count Loop
3040: IF l_debug THEN
3041: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Calling AS_SALES_LEAD_OPP_PKG.Lead_Opp_Lines_Insert_Row' ||
3042: l_sales_lead_line_tbl(l_index).sales_lead_line_id ||
3043: ',' || l_line_out_tbl(l_index).lead_line_id);
3044: END IF;
3045:

Line 3088: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Copy sales lead contacts data to opp');

3084: -- opportunity contact table
3085:
3086: -- Copy sales lead contacts data to opportunity record contacts
3087: IF l_debug THEN
3088: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Copy sales lead contacts data to opp');
3089: END IF;
3090: l_cnt := 0;
3091: For C_SL_Contacts_Rec In C_Get_Sales_lead_Contacts(P_Sales_Lead_Id) Loop
3092: l_cnt := l_cnt + 1;

Line 3138: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Calling AS_OPP_CONTACT_PVT.Create_Opp_contacts');

3134:
3135: IF l_contact_tbl.count > 0
3136: THEN
3137: IF l_debug THEN
3138: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Calling AS_OPP_CONTACT_PVT.Create_Opp_contacts');
3139: END IF;
3140:
3141: -- ffang 030503, bug 2826512, call PUB instead of PVT
3142: -- AS_OPP_CONTACT_PVT.Create_opp_contacts (

Line 3197: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Calling Update_sales_lead');

3193: := l_Sales_Lead_Rec.assign_sales_group_id;
3194: -- end ffang 020301
3195:
3196: IF l_debug THEN
3197: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Calling Update_sales_lead');
3198: END IF;
3199:
3200: -- ffang 030503, bug 2826512, call PUB instead of PVT
3201: -- AS_SALES_LEADS_PVT.Update_sales_lead(

Line 3329: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Calling Create_SalesTeam');

3325: -- end ffang 031103, bug 2844916
3326: -- end ffang 062502
3327:
3328: IF l_debug THEN
3329: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Calling Create_SalesTeam');
3330: END IF;
3331:
3332: AS_ACCESS_PUB.Create_SalesTeam (
3333: p_api_version_number => 2.0

Line 3350: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'access_id : ' || l_Access_Id);

3346: ,x_access_id => l_Access_Id
3347: );
3348:
3349: IF l_debug THEN
3350: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'access_id : ' || l_Access_Id);
3351: END IF;
3352: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3353: RAISE FND_API.G_EXC_ERROR;
3354: END IF;

Line 3409: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'access_id of preferred partner: ' || l_Access_Id);

3405: x_msg_count => X_Msg_Count,
3406: x_msg_data => X_Msg_Data,
3407: x_access_id => l_Access_Id);
3408: IF l_debug THEN
3409: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'access_id of preferred partner: ' || l_Access_Id);
3410: END IF;
3411: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3412: RAISE FND_API.G_EXC_ERROR;
3413: END IF;

Line 3430: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'PVT: ' || l_api_name || ' End');

3426:
3427:
3428: -- Debug Message
3429: IF l_debug THEN
3430: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'PVT: ' || l_api_name || ' End');
3431: END IF;
3432:
3433: -- Standard call to get message count and IF count is 1, get message info.
3434: FND_MSG_PUB.Count_And_Get

Line 3440: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

3436: p_data => x_msg_data );
3437:
3438: EXCEPTION
3439: WHEN FND_API.G_EXC_ERROR THEN
3440: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3441: P_MODULE => l_module
3442: ,P_API_NAME => L_API_NAME
3443: ,P_PKG_NAME => G_PKG_NAME
3444: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 3445: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

3441: P_MODULE => l_module
3442: ,P_API_NAME => L_API_NAME
3443: ,P_PKG_NAME => G_PKG_NAME
3444: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3445: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
3446: ,X_MSG_COUNT => X_MSG_COUNT
3447: ,X_MSG_DATA => X_MSG_DATA
3448: ,X_RETURN_STATUS => X_RETURN_STATUS);
3449:

Line 3451: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

3447: ,X_MSG_DATA => X_MSG_DATA
3448: ,X_RETURN_STATUS => X_RETURN_STATUS);
3449:
3450: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3451: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3452: P_MODULE => l_module
3453: ,P_API_NAME => L_API_NAME
3454: ,P_PKG_NAME => G_PKG_NAME
3455: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 3456: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

3452: P_MODULE => l_module
3453: ,P_API_NAME => L_API_NAME
3454: ,P_PKG_NAME => G_PKG_NAME
3455: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3456: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
3457: ,X_MSG_COUNT => X_MSG_COUNT
3458: ,X_MSG_DATA => X_MSG_DATA
3459: ,X_RETURN_STATUS => X_RETURN_STATUS);
3460:

Line 3462: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

3458: ,X_MSG_DATA => X_MSG_DATA
3459: ,X_RETURN_STATUS => X_RETURN_STATUS);
3460:
3461: WHEN OTHERS THEN
3462: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3463: P_MODULE => l_module
3464: ,P_API_NAME => L_API_NAME
3465: ,P_PKG_NAME => G_PKG_NAME
3466: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 3466: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

3462: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3463: P_MODULE => l_module
3464: ,P_API_NAME => L_API_NAME
3465: ,P_PKG_NAME => G_PKG_NAME
3466: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
3467: ,P_SQLCODE => SQLCODE
3468: ,P_SQLERRM => SQLERRM
3469: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
3470: ,X_MSG_COUNT => X_MSG_COUNT

Line 3469: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

3465: ,P_PKG_NAME => G_PKG_NAME
3466: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
3467: ,P_SQLCODE => SQLCODE
3468: ,P_SQLERRM => SQLERRM
3469: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
3470: ,X_MSG_COUNT => X_MSG_COUNT
3471: ,X_MSG_DATA => X_MSG_DATA
3472: ,X_RETURN_STATUS => X_RETURN_STATUS);
3473:

Line 3623: AS_UTILITY_PVT.Set_Message(

3619: nvl(l_applicability,'BOTH') NOT IN ('OPPORTUNITY', 'BOTH') THEN
3620: OPEN c_first_sales_stage(l_sales_methodology_id);
3621: FETCH c_first_sales_stage INTO l_sales_stage_id;
3622: IF c_first_sales_stage%NOTFOUND THEN
3623: AS_UTILITY_PVT.Set_Message(
3624: p_module => l_module,
3625: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
3626: p_msg_name => 'AS_STAGE_NOT_SETUP_FOR_METH');
3627: x_return_status :=FND_API.G_RET_STS_ERROR;

Line 3636: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

3632: X_sales_stage_id := l_sales_stage_id;
3633: X_sales_methodology_id := l_sales_methodology_id;
3634: EXCEPTION
3635: WHEN FND_API.G_EXC_ERROR THEN
3636: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3637: P_MODULE => l_module
3638: ,P_API_NAME => L_API_NAME
3639: ,P_PKG_NAME => G_PKG_NAME
3640: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 3641: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

3637: P_MODULE => l_module
3638: ,P_API_NAME => L_API_NAME
3639: ,P_PKG_NAME => G_PKG_NAME
3640: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3641: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
3642: ,X_MSG_COUNT => X_MSG_COUNT
3643: ,X_MSG_DATA => X_MSG_DATA
3644: ,X_RETURN_STATUS => X_RETURN_STATUS);
3645:

Line 3647: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

3643: ,X_MSG_DATA => X_MSG_DATA
3644: ,X_RETURN_STATUS => X_RETURN_STATUS);
3645:
3646: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3647: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3648: P_MODULE => l_module
3649: ,P_API_NAME => L_API_NAME
3650: ,P_PKG_NAME => G_PKG_NAME
3651: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 3652: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

3648: P_MODULE => l_module
3649: ,P_API_NAME => L_API_NAME
3650: ,P_PKG_NAME => G_PKG_NAME
3651: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3652: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
3653: ,X_MSG_COUNT => X_MSG_COUNT
3654: ,X_MSG_DATA => X_MSG_DATA
3655: ,X_RETURN_STATUS => X_RETURN_STATUS);
3656:

Line 3658: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

3654: ,X_MSG_DATA => X_MSG_DATA
3655: ,X_RETURN_STATUS => X_RETURN_STATUS);
3656:
3657: WHEN OTHERS THEN
3658: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3659: P_MODULE => l_module
3660: ,P_API_NAME => L_API_NAME
3661: ,P_PKG_NAME => G_PKG_NAME
3662: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 3662: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

3658: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3659: P_MODULE => l_module
3660: ,P_API_NAME => L_API_NAME
3661: ,P_PKG_NAME => G_PKG_NAME
3662: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
3663: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
3664: ,X_MSG_COUNT => X_MSG_COUNT
3665: ,X_MSG_DATA => X_MSG_DATA
3666: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 3663: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

3659: P_MODULE => l_module
3660: ,P_API_NAME => L_API_NAME
3661: ,P_PKG_NAME => G_PKG_NAME
3662: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
3663: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
3664: ,X_MSG_COUNT => X_MSG_COUNT
3665: ,X_MSG_DATA => X_MSG_DATA
3666: ,X_RETURN_STATUS => X_RETURN_STATUS);
3667: END CHECK_SALES_STAGE;