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_DIRECT_ASSIGN_WRAPPER_PUB dependencies on FND_API

Line 33: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

29: --| |
30: --==============================================================================
31:
32: Procedure Create_Assignment_Wrapper ( p_api_version_number IN NUMBER
33: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
34: ,p_commit IN VARCHAR2 := FND_API.G_TRUE
35: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
36: ,p_entity IN VARCHAR2
37: ,p_lead_id IN NUMBER

Line 34: ,p_commit IN VARCHAR2 := FND_API.G_TRUE

30: --==============================================================================
31:
32: Procedure Create_Assignment_Wrapper ( p_api_version_number IN NUMBER
33: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
34: ,p_commit IN VARCHAR2 := FND_API.G_TRUE
35: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
36: ,p_entity IN VARCHAR2
37: ,p_lead_id IN NUMBER
38: ,p_creating_username IN VARCHAR2

Line 35: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

31:
32: Procedure Create_Assignment_Wrapper ( p_api_version_number IN NUMBER
33: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
34: ,p_commit IN VARCHAR2 := FND_API.G_TRUE
35: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
36: ,p_entity IN VARCHAR2
37: ,p_lead_id IN NUMBER
38: ,p_creating_username IN VARCHAR2
39: ,p_bypass_cm_ok_flag IN VARCHAR2

Line 71: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

67: Begin
68: SAVEPOINT Create_Assignment_Wrapper;
69:
70: -- Standard call to check for call compatibility.
71: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
72: p_api_version_number,
73: l_api_name,
74: G_PKG_NAME) THEN
75:

Line 76: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

72: p_api_version_number,
73: l_api_name,
74: G_PKG_NAME) THEN
75:
76: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
77:
78: END IF;
79:
80: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 81: IF FND_API.to_Boolean( p_init_msg_list )

77:
78: END IF;
79:
80: -- Initialize message list if p_init_msg_list is set to TRUE.
81: IF FND_API.to_Boolean( p_init_msg_list )
82: THEN
83: fnd_msg_pub.initialize;
84: END IF;
85:

Line 89: x_return_status := FND_API.G_RET_STS_SUCCESS ;

85:
86: l_partner_id_tbl := JTF_NUMBER_TABLE();
87: l_rank_tbl := JTF_NUMBER_TABLE();
88: l_partner_source_tbl := JTF_VARCHAR2_TABLE_100();
89: x_return_status := FND_API.G_RET_STS_SUCCESS ;
90:
91: IF ( p_lead_id is NULL ) THEN
92: fnd_message.SET_NAME('PV', 'PV_NULL_LEAD_ID');
93: fnd_msg_pub.ADD;

Line 94: raise FND_API.G_EXC_ERROR;

90:
91: IF ( p_lead_id is NULL ) THEN
92: fnd_message.SET_NAME('PV', 'PV_NULL_LEAD_ID');
93: fnd_msg_pub.ADD;
94: raise FND_API.G_EXC_ERROR;
95: END IF;
96:
97: IF ( p_creating_username is NULL ) THEN
98: fnd_message.SET_NAME('PV', 'PV_NULL_CREATE_USER');

Line 100: raise FND_API.G_EXC_ERROR;

96:
97: IF ( p_creating_username is NULL ) THEN
98: fnd_message.SET_NAME('PV', 'PV_NULL_CREATE_USER');
99: fnd_msg_pub.ADD;
100: raise FND_API.G_EXC_ERROR;
101: END IF;
102:
103: IF ( p_bypass_cm_ok_flag is NULL ) THEN
104: fnd_message.SET_NAME('PV', 'PV_NULL_CMBYPASS_FLAG');

Line 106: RAISE FND_API.G_EXC_ERROR;

102:
103: IF ( p_bypass_cm_ok_flag is NULL ) THEN
104: fnd_message.SET_NAME('PV', 'PV_NULL_CMBYPASS_FLAG');
105: fnd_msg_pub.ADD;
106: RAISE FND_API.G_EXC_ERROR;
107: END IF;
108:
109: --IF (p_entity is NULL) or p_entity not in ('LEAD', 'OPPORTUNITY') THEN
110: IF (p_entity is NULL) or p_entity <> 'OPPORTUNITY' THEN

Line 113: RAISE FND_API.G_EXC_ERROR;

109: --IF (p_entity is NULL) or p_entity not in ('LEAD', 'OPPORTUNITY') THEN
110: IF (p_entity is NULL) or p_entity <> 'OPPORTUNITY' THEN
111: fnd_message.SET_NAME('PV', 'PV_INVALID_ENTITY');
112: fnd_msg_pub.ADD;
113: RAISE FND_API.G_EXC_ERROR;
114: END IF;
115:
116: l_assigned_partners := 'select asla.INCUMBENT_PARTNER_PARTY_ID ' ||
117: 'from as_leads_all asla ' ||

Line 148: ,p_init_msg_list => FND_API.G_TRUE

144: END IF;
145:
146: PV_ASSIGNMENT_PUB.CREATEASSIGNMENT (
147: p_api_version_number => 1.0
148: ,p_init_msg_list => FND_API.G_TRUE
149: ,p_commit => FND_API.G_TRUE
150: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
151: ,p_entity => p_entity
152: ,p_lead_id => p_lead_id

Line 149: ,p_commit => FND_API.G_TRUE

145:
146: PV_ASSIGNMENT_PUB.CREATEASSIGNMENT (
147: p_api_version_number => 1.0
148: ,p_init_msg_list => FND_API.G_TRUE
149: ,p_commit => FND_API.G_TRUE
150: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
151: ,p_entity => p_entity
152: ,p_lead_id => p_lead_id
153: ,p_creating_username => p_creating_username

Line 150: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

146: PV_ASSIGNMENT_PUB.CREATEASSIGNMENT (
147: p_api_version_number => 1.0
148: ,p_init_msg_list => FND_API.G_TRUE
149: ,p_commit => FND_API.G_TRUE
150: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
151: ,p_entity => p_entity
152: ,p_lead_id => p_lead_id
153: ,p_creating_username => p_creating_username
154: ,p_assignment_type => l_assignment_type

Line 166: IF x_return_status = FND_API.g_ret_sts_error THEN

162: ,x_msg_data => x_msg_data
163: );
164:
165: -- If API call returns Error raise Exception. Fix for Bug#2052029
166: IF x_return_status = FND_API.g_ret_sts_error THEN
167: RAISE FND_API.G_EXC_ERROR;
168: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
170: END IF;

Line 167: RAISE FND_API.G_EXC_ERROR;

163: );
164:
165: -- If API call returns Error raise Exception. Fix for Bug#2052029
166: IF x_return_status = FND_API.g_ret_sts_error THEN
167: RAISE FND_API.G_EXC_ERROR;
168: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
170: END IF;
171: ELSE

Line 168: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

164:
165: -- If API call returns Error raise Exception. Fix for Bug#2052029
166: IF x_return_status = FND_API.g_ret_sts_error THEN
167: RAISE FND_API.G_EXC_ERROR;
168: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
170: END IF;
171: ELSE
172: fnd_message.SET_NAME('PV', 'PV_NO_PRTNR_TO_ROUTE');

Line 169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

165: -- If API call returns Error raise Exception. Fix for Bug#2052029
166: IF x_return_status = FND_API.g_ret_sts_error THEN
167: RAISE FND_API.G_EXC_ERROR;
168: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
170: END IF;
171: ELSE
172: fnd_message.SET_NAME('PV', 'PV_NO_PRTNR_TO_ROUTE');
173: fnd_msg_pub.ADD;

Line 174: raise FND_API.G_EXC_ERROR;

170: END IF;
171: ELSE
172: fnd_message.SET_NAME('PV', 'PV_NO_PRTNR_TO_ROUTE');
173: fnd_msg_pub.ADD;
174: raise FND_API.G_EXC_ERROR;
175: END IF;
176:
177: IF FND_API.To_Boolean ( p_commit ) THEN
178: COMMIT WORK;

Line 177: IF FND_API.To_Boolean ( p_commit ) THEN

173: fnd_msg_pub.ADD;
174: raise FND_API.G_EXC_ERROR;
175: END IF;
176:
177: IF FND_API.To_Boolean ( p_commit ) THEN
178: COMMIT WORK;
179: END IF;
180:
181: -- Standard call to get message count and if count is 1, get message info.

Line 182: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,

178: COMMIT WORK;
179: END IF;
180:
181: -- Standard call to get message count and if count is 1, get message info.
182: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
183: p_count => x_msg_count,
184: p_data => x_msg_data);
185:
186: EXCEPTION

Line 188: WHEN FND_API.G_EXC_ERROR THEN

184: p_data => x_msg_data);
185:
186: EXCEPTION
187:
188: WHEN FND_API.G_EXC_ERROR THEN
189:
190: ROLLBACK TO Create_Assignment_Wrapper;
191: x_return_status := FND_API.G_RET_STS_ERROR ;
192:

Line 191: x_return_status := FND_API.G_RET_STS_ERROR ;

187:
188: WHEN FND_API.G_EXC_ERROR THEN
189:
190: ROLLBACK TO Create_Assignment_Wrapper;
191: x_return_status := FND_API.G_RET_STS_ERROR ;
192:
193: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
194: p_count => x_msg_count,
195: p_data => x_msg_data);

Line 193: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,

189:
190: ROLLBACK TO Create_Assignment_Wrapper;
191: x_return_status := FND_API.G_RET_STS_ERROR ;
192:
193: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
194: p_count => x_msg_count,
195: p_data => x_msg_data);
196:
197: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 197: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

193: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
194: p_count => x_msg_count,
195: p_data => x_msg_data);
196:
197: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
198:
199: ROLLBACK TO Create_Assignment_Wrapper;
200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
201:

Line 200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

196:
197: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
198:
199: ROLLBACK TO Create_Assignment_Wrapper;
200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
201:
202: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
203: p_count => x_msg_count,
204: p_data => x_msg_data);

Line 202: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,

198:
199: ROLLBACK TO Create_Assignment_Wrapper;
200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
201:
202: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
203: p_count => x_msg_count,
204: p_data => x_msg_data);
205:
206: WHEN OTHERS THEN

Line 209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

205:
206: WHEN OTHERS THEN
207:
208: ROLLBACK TO Create_Assignment_Wrapper;
209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
210:
211: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
212:
213: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,

Line 213: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,

209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
210:
211: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
212:
213: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
214: p_count => x_msg_count,
215: p_data => x_msg_data);
216:
217: