DBA Data[Home] [Help]

APPS.AS_SALES_LEADS_PVT dependencies on STANDARD

Line 22: -- handling to meet the coding standard

18: -- 09/20/2000 FFANG For bug 1400244, add a procedure: set_default_values
19: -- to set currency_code as user default value, if
20: -- budget_amount is entered but not currency_code
21: -- 09/21/2000 FFANG For bug 1400264, add two lines to others exception
22: -- handling to meet the coding standard
23: -- 09/26/2000 FFANG Correct procedure 'Validate_PRM_IND_CLS_CODE':
24: -- lookup_type should be 'PRM_IND_CLASSIFICATION_TYPE'
25: -- 09/27/2000 FFANG Use AS_INTEREST_PVT.Validate_Interest_Fields instead
26: -- of Validate_Intrst_Type_Sec_CODE

Line 318: -- Standard call to get message count and IF count is 1, get message info.

314: END IF;
315: END IF;
316: END IF;
317:
318: -- Standard call to get message count and IF count is 1, get message info.
319: FND_MSG_PUB.Count_And_Get
320: ( p_count => x_msg_count,
321: p_data => x_msg_data );
322: END Validate_LEAD_NUMBER;

Line 410: -- Standard call to get message count and IF count is 1, get message info.

406: END IF;
407: END IF;
408: -- end ffang 092000 for bug 1306777
409:
410: -- Standard call to get message count and IF count is 1, get message info.
411: FND_MSG_PUB.Count_And_Get
412: ( p_count => x_msg_count,
413: p_data => x_msg_data );
414:

Line 495: -- Standard call to get message count and IF count is 1, get message info.

491: CLOSE C_Methodology_Exists;
492: END IF;
493:
494:
495: -- Standard call to get message count and IF count is 1, get message info.
496: FND_MSG_PUB.Count_And_Get
497: ( p_count => x_msg_count,
498: p_data => x_msg_data );
499: END Validate_Sales_Methodology_ID;

Line 579: -- Standard call to get message count and IF count is 1, get message info.

575: CLOSE C_Sales_Stage_Exists;
576: END IF;
577:
578:
579: -- Standard call to get message count and IF count is 1, get message info.
580: FND_MSG_PUB.Count_And_Get
581: ( p_count => x_msg_count,
582: p_data => x_msg_data );
583: END Validate_Sales_Stage_ID;

Line 693: -- Standard call to get message count and if count is 1, get message info.

689:
690:
691: END IF;
692:
693: -- Standard call to get message count and if count is 1, get message info.
694: FND_MSG_PUB.Count_And_Get
695: ( p_count => x_msg_count,
696: p_data => x_msg_data
697: );

Line 799: -- Standard call to get message count and if count is 1, get message info.

795: x_return_status := FND_API.G_RET_STS_ERROR;
796: END IF;
797: END IF;
798:
799: -- Standard call to get message count and if count is 1, get message info.
800: FND_MSG_PUB.Count_And_Get
801: ( p_count => x_msg_count,
802: p_data => x_msg_data
803: );

Line 978: -- Standard call to get message count and IF count is 1, get message info.

974: end if; */
975:
976:
977:
978: -- Standard call to get message count and IF count is 1, get message info.
979: FND_MSG_PUB.Count_And_Get
980: ( p_count => x_msg_count,
981: p_data => x_msg_data );
982: END Validate_STATUS_CODE;

Line 1076: -- Standard call to get message count and IF count is 1, get message info.

1072: CLOSE C_Promotion_Exists;
1073: END IF;
1074:
1075:
1076: -- Standard call to get message count and IF count is 1, get message info.
1077: FND_MSG_PUB.Count_And_Get
1078: ( p_count => x_msg_count,
1079: p_data => x_msg_data );
1080: END Validate_SOURCE_PROMOTION_ID;

Line 1137: -- Standard call to get message count and IF count is 1, get message info.

1133: END IF;
1134: CLOSE C_Aso_Channel_Exists;
1135: END IF;
1136:
1137: -- Standard call to get message count and IF count is 1, get message info.
1138: FND_MSG_PUB.Count_And_Get
1139: ( p_count => x_msg_count,
1140: p_data => x_msg_data );
1141: END Validate_CHANNEL_CODE;

Line 1199: -- Standard call to get message count and IF count is 1, get message info.

1195: END IF;
1196: CLOSE C_Currency_Exists;
1197: END IF;
1198:
1199: -- Standard call to get message count and IF count is 1, get message info.
1200: FND_MSG_PUB.Count_And_Get
1201: ( p_count => x_msg_count,
1202: p_data => x_msg_data );
1203: END Validate_CURRENCY_CODE;

Line 1320: -- Standard call to get message count and IF count is 1, get message info.

1316: x_return_status := FND_API.G_RET_STS_ERROR;
1317: END IF;
1318: CLOSE C_Lookup_Exists;
1319: END IF;
1320: -- Standard call to get message count and IF count is 1, get message info.
1321: FND_MSG_PUB.Count_And_Get
1322: ( p_count => x_msg_count,
1323: p_data => x_msg_data );
1324: END Validate_CLOSE_REASON;

Line 1576: -- Standard call to get message count and IF count is 1, get message info.

1572: END IF;
1573: CLOSE C_Lookup_Exists;
1574: END IF;
1575:
1576: -- Standard call to get message count and IF count is 1, get message info.
1577: FND_MSG_PUB.Count_And_Get
1578: ( p_count => x_msg_count,
1579: p_data => x_msg_data );
1580: END Validate_BUDGET_STATUS_CODE;

Line 1636: -- Standard call to get message count and IF count is 1, get message info.

1632: END IF;
1633: CLOSE C_Lookup_Exists;
1634: END IF;
1635:
1636: -- Standard call to get message count and IF count is 1, get message info.
1637: FND_MSG_PUB.Count_And_Get
1638: ( p_count => x_msg_count,
1639: p_data => x_msg_data );
1640: END Validate_VEHICLE_RESPONSE_CODE;

Line 1696: -- Standard call to get message count and IF count is 1, get message info.

1692: END IF;
1693: CLOSE C_Lookup_Exists;
1694: END IF;
1695:
1696: -- Standard call to get message count and IF count is 1, get message info.
1697: FND_MSG_PUB.Count_And_Get
1698: ( p_count => x_msg_count,
1699: p_data => x_msg_data );
1700: END Validate_REJECT_REASON_CODE;

Line 1744: -- Standard call to get message count and IF count is 1, get message info.

1740: x_return_status := FND_API.G_RET_STS_ERROR;
1741: END IF;
1742: END IF;
1743:
1744: -- Standard call to get message count and IF count is 1, get message info.
1745: FND_MSG_PUB.Count_And_Get
1746: ( p_count => x_msg_count,
1747: p_data => x_msg_data );
1748: END Validate_FLAGS;

Line 1792: -- Standard call to get message count and IF count is 1, get message info.

1788: x_return_status := FND_API.G_RET_STS_ERROR;
1789: END IF;
1790: END IF;
1791:
1792: -- Standard call to get message count and IF count is 1, get message info.
1793: FND_MSG_PUB.Count_And_Get
1794: ( p_count => x_msg_count,
1795: p_data => x_msg_data );
1796: END Validate_ACCEPT_REJECT_REASON;

Line 1905: -- Standard call to get message count and IF count is 1, get message info.

1901: CLOSE C_Status_Exists ;
1902:
1903:
1904:
1905: -- Standard call to get message count and IF count is 1, get message info.
1906: FND_MSG_PUB.Count_And_Get
1907: ( p_count => x_msg_count,
1908: p_data => x_msg_data );
1909: END Validate_STATUS_CLOSE_REASON;

Line 1985: -- Standard call to get message count and IF count is 1, get message info.

1981:
1982:
1983: END IF;
1984:
1985: -- Standard call to get message count and IF count is 1, get message info.
1986: FND_MSG_PUB.Count_And_Get
1987: ( p_count => x_msg_count,
1988: p_data => x_msg_data );
1989: END Validate_REF_BY_REF_TYPE;

Line 2066: -- Standard call to get message count and IF count is 1, get message info.

2062: END IF;
2063: CLOSE C_OFFER_ID_Exists;
2064: END IF;
2065:
2066: -- Standard call to get message count and IF count is 1, get message info.
2067: FND_MSG_PUB.Count_And_Get
2068: ( p_count => x_msg_count,
2069: p_data => x_msg_data
2070: );

Line 2130: -- Standard call to get message count and if count is 1, get message info.

2126: CLOSE C_INC_PRTN_PARTY_ID_Exist;
2127: -- end ffang 092800
2128: END IF;
2129:
2130: -- Standard call to get message count and if count is 1, get message info.
2131: FND_MSG_PUB.Count_And_Get
2132: ( p_count => x_msg_count,
2133: p_data => x_msg_data
2134: );

Line 2196: -- Standard call to get message count and if count is 1, get message info.

2192:
2193: CLOSE C_RESOURCE_ID_Exists;
2194: END IF;
2195:
2196: -- Standard call to get message count and if count is 1, get message info.
2197: FND_MSG_PUB.Count_And_Get
2198: ( p_count => x_msg_count,
2199: p_data => x_msg_data
2200: );

Line 2253: -- Standard call to get message count and IF count is 1, get message info.

2249: x_return_status := FND_API.G_RET_STS_ERROR;
2250: END IF;
2251: END IF;
2252:
2253: -- Standard call to get message count and IF count is 1, get message info.
2254: FND_MSG_PUB.Count_And_Get
2255: ( p_count => x_msg_count,
2256: p_data => x_msg_data
2257: );

Line 2310: -- Standard call to get message count and IF count is 1, get message info.

2306: x_return_status := FND_API.G_RET_STS_ERROR;
2307: END IF;
2308: END IF;
2309:
2310: -- Standard call to get message count and IF count is 1, get message info.
2311: FND_MSG_PUB.Count_And_Get
2312: ( p_count => x_msg_count,
2313: p_data => x_msg_data
2314: );

Line 2377: -- Standard call to get message count and IF count is 1, get message info.

2373: END IF;
2374: CLOSE C_PRM_LEAD_TYPE_Exists;
2375: END IF;
2376:
2377: -- Standard call to get message count and IF count is 1, get message info.
2378: FND_MSG_PUB.Count_And_Get
2379: ( p_count => x_msg_count,
2380: p_data => x_msg_data
2381: );

Line 2444: -- Standard call to get message count and IF count is 1, get message info.

2440: END IF;
2441: CLOSE C_PRM_IND_CLS_CODE_Exists;
2442: END IF;
2443:
2444: -- Standard call to get message count and IF count is 1, get message info.
2445: FND_MSG_PUB.Count_And_Get
2446: ( p_count => x_msg_count,
2447: p_data => x_msg_data
2448: );

Line 2508: -- Standard call to get message count and if count is 1, get message info.

2504:
2505: CLOSE C_AUTO_ASGN_TYPE_Exists;
2506: END IF;
2507:
2508: -- Standard call to get message count and if count is 1, get message info.
2509: FND_MSG_PUB.Count_And_Get
2510: ( p_count => x_msg_count,
2511: p_data => x_msg_data
2512: );

Line 2569: -- Standard call to get message count and if count is 1, get message info.

2565:
2566: CLOSE C_PRM_ASGN_TYPE_Exists;
2567: END IF;
2568:
2569: -- Standard call to get message count and if count is 1, get message info.
2570: FND_MSG_PUB.Count_And_Get
2571: ( p_count => x_msg_count,
2572: p_data => x_msg_data
2573: );

Line 2641: -- Standard call to get message count and IF count is 1, get message info.

2637: p_msg_name => 'AS_BUDGET_AMOUNT_NOT_MATCH');
2638: x_return_status := FND_API.G_RET_STS_ERROR;
2639: END IF;
2640:
2641: -- Standard call to get message count and IF count is 1, get message info.
2642: FND_MSG_PUB.Count_And_Get
2643: ( p_count => x_msg_count,
2644: p_data => x_msg_data );
2645: END Validate_Budget_Amounts;

Line 3370: -- Standard Start of API savepoint

3366:
3367:
3368:
3369: BEGIN
3370: -- Standard Start of API savepoint
3371: SAVEPOINT CREATE_SALES_LEAD_PVT;
3372:
3373: -- Standard call to check for call compatibility.
3374: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 3373: -- Standard call to check for call compatibility.

3369: BEGIN
3370: -- Standard Start of API savepoint
3371: SAVEPOINT CREATE_SALES_LEAD_PVT;
3372:
3373: -- Standard call to check for call compatibility.
3374: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3375: p_api_version_number,
3376: l_api_name,
3377: G_PKG_NAME )

Line 3916: -- using standard parameters for program who columns

3912: p_creation_date => sysdate,
3913: p_last_updated_by => fnd_global.user_id,
3914: p_last_update_date => sysdate,
3915: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
3916: -- using standard parameters for program who columns
3917: p_request_id => FND_GLOBAL.Conc_Request_Id,
3918: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,
3919: p_program_id => FND_GLOBAL.Conc_Program_Id,
3920: p_program_update_date => sysdate,

Line 3951: -- using standard parameters for program who columns

3947: p_creation_date => sysdate,
3948: p_last_updated_by => fnd_global.user_id,
3949: p_last_update_date => sysdate,
3950: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
3951: -- using standard parameters for program who columns
3952: p_request_id => FND_GLOBAL.Conc_Request_Id,
3953: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,
3954: p_program_id => FND_GLOBAL.Conc_Program_Id,
3955: p_program_update_date => sysdate,

Line 4235: -- Standard check for p_commit

4231: --
4232: -- END of API body
4233: --
4234:
4235: -- Standard check for p_commit
4236: IF FND_API.to_Boolean( p_commit )
4237: THEN
4238: COMMIT WORK;
4239: END IF;

Line 4248: -- Standard call to get message count and IF count is 1, get message info.

4244: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4245: 'PVT: ' || l_api_name || ' End');
4246: END IF;
4247:
4248: -- Standard call to get message count and IF count is 1, get message info.
4249: FND_MSG_PUB.Count_And_Get
4250: ( p_count => x_msg_count,
4251: p_data => x_msg_data );
4252:

Line 4591: -- Standard Start of API savepoint

4587: l_country_code VARCHAR2(60) := FND_API.G_MISS_CHAR; --Default value added by bmuthukr for bug 3675566
4588:
4589:
4590: BEGIN
4591: -- Standard Start of API savepoint
4592: SAVEPOINT UPDATE_SALES_LEAD_PVT;
4593:
4594: -- Standard call to check for call compatibility.
4595: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 4594: -- Standard call to check for call compatibility.

4590: BEGIN
4591: -- Standard Start of API savepoint
4592: SAVEPOINT UPDATE_SALES_LEAD_PVT;
4593:
4594: -- Standard call to check for call compatibility.
4595: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
4596: p_api_version_number,
4597: l_api_name,
4598: G_PKG_NAME)

Line 5598: -- using standard parameters for program who columns

5594: p_creation_date => sysdate,
5595: p_last_updated_by => fnd_global.user_id,
5596: p_last_update_date => sysdate,
5597: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
5598: -- using standard parameters for program who columns
5599: p_request_id => FND_GLOBAL.Conc_Request_Id,
5600: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,
5601: p_program_id => FND_GLOBAL.Conc_Program_Id,
5602: p_program_update_date => sysdate,

Line 5659: -- using standard parameters for program who columns

5655: p_creation_date => sysdate,
5656: p_last_updated_by => fnd_global.user_id,
5657: p_last_update_date => sysdate,
5658: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
5659: -- using standard parameters for program who columns
5660: p_request_id => FND_GLOBAL.Conc_Request_Id,
5661: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,
5662: p_program_id => FND_GLOBAL.Conc_Program_Id,
5663: p_program_update_date => sysdate,

Line 6424: -- Standard check for p_commit

6420: --
6421: -- END of API body.
6422: --
6423:
6424: -- Standard check for p_commit
6425: IF FND_API.to_Boolean( p_commit )
6426: THEN
6427: COMMIT WORK;
6428: END IF;

Line 6437: -- Standard call to get message count and IF count is 1, get message info.

6433: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
6434: 'PVT: ' || l_api_name || ' End');
6435: END IF;
6436:
6437: -- Standard call to get message count and IF count is 1, get message info.
6438: FND_MSG_PUB.Count_And_Get
6439: ( p_count => x_msg_count,
6440: p_data => x_msg_data );
6441: