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.PV_TERR_ASSIGN_PUB dependencies on STANDARD

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

1941:
1942: -- Store in the output variable.
1943: x_partner_qualifiers_tbl := l_partner_qualifiers_tbl;
1944:
1945: -- Standard call to get message count and if count is 1, get message info.
1946: FND_MSG_PUB.Count_And_Get
1947: (p_count => x_msg_count,
1948: p_data => x_msg_data
1949: );

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

2142: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2143: PVX_UTILITY_PVT.debug_message('Private Procedure: ' || l_api_name || 'end.');
2144: END IF;
2145:
2146: -- Standard call to get message count and if count is 1, get message info.
2147: FND_MSG_PUB.Count_And_Get
2148: (p_count => x_msg_count,
2149: p_data => x_msg_data
2150: );

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

2320: AND terr_id = cv_terr_id;
2321:
2322: BEGIN
2323:
2324: -- Standard call to check for call compatibility.
2325: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2326: p_api_version_number,
2327: l_api_name,
2328: G_PKG_NAME)

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

2635: SELECT nvl(fnd_profile.value(cv_profile_name),0) from dual;
2636:
2637: BEGIN
2638:
2639: -- Standard call to check for call compatibility.
2640: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2641: p_api_version_number,
2642: l_api_name,
2643: G_PKG_NAME)

Line 2841: -- Standard check for p_commit

2837:
2838: END IF ; -- check_resource_exist
2839: END IF; -- l_cm_added <> 'Y'
2840:
2841: -- Standard check for p_commit
2842: IF FND_API.to_Boolean( p_commit )
2843: THEN
2844: COMMIT WORK;
2845: END IF;

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

2848: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2849: PVX_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
2850: END IF;
2851:
2852: -- Standard call to get message count and if count is 1, get message info.
2853: FND_MSG_PUB.Count_And_Get
2854: (p_count => x_msg_count,
2855: p_data => x_msg_data
2856: );

Line 3007: -- Standard Start of API savepoint

3003: SELECT fnd_profile.value(cv_profile_name) from dual;
3004:
3005: BEGIN
3006:
3007: -- Standard Start of API savepoint
3008: SAVEPOINT create_channel_team_pub;
3009:
3010: -- Standard call to check for call compatibility.
3011: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

3006:
3007: -- Standard Start of API savepoint
3008: SAVEPOINT create_channel_team_pub;
3009:
3010: -- Standard call to check for call compatibility.
3011: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3012: p_api_version_number,
3013: l_api_name,
3014: G_PKG_NAME)

Line 3214: -- Standard check for p_commit

3210:
3211: END IF;
3212:
3213:
3214: -- Standard check for p_commit
3215: IF FND_API.to_Boolean( p_commit )
3216: THEN
3217: COMMIT WORK;
3218: END IF;

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

3221: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3222: PVX_UTILITY_PVT.debug_message('Public API: ' || l_api_name || ' End');
3223: END IF;
3224:
3225: -- Standard call to get message count and if count is 1, get message info.
3226: FND_MSG_PUB.Count_And_Get
3227: (p_count => x_msg_count,
3228: p_data => x_msg_data
3229: );

Line 3379: -- Standard Start of API savepoint

3375:
3376:
3377: BEGIN
3378:
3379: -- Standard Start of API savepoint
3380: SAVEPOINT create_channel_team_pub;
3381:
3382: -- Get the Partner Party Id for the given Partner_Id
3383: OPEN l_party_id_csr(l_partner_id);

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

3587: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3588: PVX_Utility_PVT.debug_message('This procedure is not in use');
3589: END IF;
3590: /*
3591: -- Standard call to check for call compatibility.
3592: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3593: p_api_version_number,
3594: l_api_name,
3595: G_PKG_NAME)

Line 3943: -- Standard check for p_commit

3939:
3940: END IF ; -- check_resource_exist
3941: END IF; -- l_cm_added <> 'Y'
3942:
3943: -- Standard check for p_commit
3944: IF FND_API.to_Boolean( p_commit )
3945: THEN
3946: COMMIT WORK;
3947: END IF;

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

3950: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3951: PVX_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
3952: END IF;
3953:
3954: -- Standard call to get message count and if count is 1, get message info.
3955: FND_MSG_PUB.Count_And_Get
3956: (p_count => x_msg_count,
3957: p_data => x_msg_data
3958: );

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

4147: AND terr_id = cv_terr_id;
4148:
4149: BEGIN
4150:
4151: -- Standard call to check for call compatibility.
4152: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
4153: p_api_version_number,
4154: l_api_name,
4155: G_PKG_NAME)

Line 4495: -- Standard check for p_commit

4491:
4492: END IF ; -- check_resource_exist
4493: END IF; -- l_cm_added <> 'Y'
4494:
4495: -- Standard check for p_commit
4496: IF FND_API.to_Boolean( p_commit )
4497: THEN
4498: COMMIT WORK;
4499: END IF;

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

4502: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
4503: PVX_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
4504: END IF;
4505:
4506: -- Standard call to get message count and if count is 1, get message info.
4507: FND_MSG_PUB.Count_And_Get
4508: (p_count => x_msg_count,
4509: p_data => x_msg_data
4510: );

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

4683: AND RES.user_id is not null;
4684:
4685: BEGIN
4686:
4687: -- Standard call to check for call compatibility.
4688: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
4689: p_api_version_number,
4690: l_api_name,
4691: G_PKG_NAME)

Line 4804: -- Standard check for p_commit

4800: --
4801: -- End of API body.
4802: --
4803:
4804: -- Standard check for p_commit
4805: IF FND_API.to_Boolean( p_commit )
4806: THEN
4807: COMMIT WORK;
4808: END IF;

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

4812: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
4813: PVX_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
4814: END IF;
4815:
4816: -- Standard call to get message count and if count is 1, get message info.
4817: FND_MSG_PUB.Count_And_Get
4818: ( p_count => l_msg_count,
4819: p_data => l_msg_data
4820: );

Line 4957: -- Standard Start of API savepoint

4953: WHERE partner_id = cv_partner_id
4954: AND status = 'A';
4955:
4956: BEGIN
4957: -- Standard Start of API savepoint
4958: SAVEPOINT Update_Channel_Team_pub;
4959:
4960: -- Standard call to check for call compatibility.
4961: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

4956: BEGIN
4957: -- Standard Start of API savepoint
4958: SAVEPOINT Update_Channel_Team_pub;
4959:
4960: -- Standard call to check for call compatibility.
4961: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
4962: p_api_version_number,
4963: l_api_name,
4964: G_PKG_NAME)

Line 5057: -- Standard check for p_commit

5053: --
5054: -- End of API body.
5055: --
5056:
5057: -- Standard check for p_commit
5058: IF FND_API.to_Boolean( p_commit )
5059: THEN
5060: COMMIT WORK;
5061: END IF;

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

5064: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
5065: PVX_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
5066: END IF;
5067:
5068: -- Standard call to get message count and if count is 1, get message info.
5069: FND_MSG_PUB.Count_And_Get
5070: ( p_count => l_msg_count,
5071: p_data => l_msg_data
5072: );

Line 5487: -- Standard Start of savepoint

5483: order by hzp.party_name;
5484:
5485:
5486: BEGIN
5487: -- Standard Start of savepoint
5488: SAVEPOINT do_Assign_Channel_Team_Pvt;
5489:
5490: -- RETCODE := FND_API.G_RET_STS_SUCCESS;
5491:

Line 5552: -- Standard Start of savepoint

5548: IF ( l_partner_list_tbl.count > 0) THEN
5549: FOR i IN 1..l_partner_list_tbl.last
5550: LOOP
5551: BEGIN
5552: -- Standard Start of savepoint
5553: SAVEPOINT Process_Partner_Channel_Team;
5554:
5555: -- Initilize the local variables.
5556: l_partner_name := l_partner_list_tbl(i).partner_name;

Line 5929: -- Standard Start of savepoint

5925: TYPE request_id_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
5926: l_request_id_tbl request_id_tbl;
5927:
5928: BEGIN
5929: -- Standard Start of savepoint
5930: SAVEPOINT Assign_Channel_Team_Pvt;
5931: l_partner_err_cnt := 0;
5932: RETCODE := FND_API.G_RET_STS_SUCCESS;
5933:

Line 6227: -- Standard Start of savepoint

6223: -- order by hzp.party_name;
6224:
6225:
6226: BEGIN
6227: -- Standard Start of savepoint
6228: SAVEPOINT Process_Sub_Territories_Pvt;
6229: -- initialize the error count to zero.
6230: l_partner_err_cnt := 0;
6231:

Line 6255: -- Standard Start of savepoint

6251: IF ( l_partner_list_tbl.count > 0) THEN
6252: FOR i IN 1..l_partner_list_tbl.last
6253: LOOP
6254: BEGIN
6255: -- Standard Start of savepoint
6256: SAVEPOINT Process_Partner_Channel_Team;
6257:
6258: -- Initilize the local variables.
6259: l_partner_id := l_partner_list_tbl(i).partner_id ;