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.CN_SCA_CREDITS_ONLINE_PUB dependencies on FND_API

Line 16: p_init_msg_list IN varchar2 := fnd_api.g_false,

12: -- + cn_sca_lines_output_GTT table. +
13: -- +=========================================================================+
14: PROCEDURE get_sales_credits(
15: p_api_version IN number,
16: p_init_msg_list IN varchar2 := fnd_api.g_false,
17: x_batch_id IN number,
18: p_org_id IN number,
19: x_return_status OUT NOCOPY varchar2,
20: x_msg_count OUT NOCOPY number,

Line 121: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

117: GROUP BY w.sca_headers_interface_id,l.role_id;
118:
119: BEGIN
120: -- Standard call to check for call compatibility.
121: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
122: p_api_version ,
123: l_api_name ,
124: G_PKG_NAME )
125: THEN

Line 126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

122: p_api_version ,
123: l_api_name ,
124: G_PKG_NAME )
125: THEN
126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
127: END IF;
128:
129: -- Initialize message list if p_init_msg_list is set to TRUE.
130: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 130: IF FND_API.to_Boolean( p_init_msg_list ) THEN

126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
127: END IF;
128:
129: -- Initialize message list if p_init_msg_list is set to TRUE.
130: IF FND_API.to_Boolean( p_init_msg_list ) THEN
131: FND_MSG_PUB.initialize;
132: END IF;
133:
134: -- Initialize API return status to success

Line 135: x_return_status := FND_API.G_RET_STS_SUCCESS;

131: FND_MSG_PUB.initialize;
132: END IF;
133:
134: -- Initialize API return status to success
135: x_return_status := FND_API.G_RET_STS_SUCCESS;
136:
137: --+
138: --+ codeCheck: Eventually this logic will be after MOAC patch is applied.
139: --+ We will validate the org_id using MO_GLOBAL.VALIDATE_ORGID_PUB_API

Line 149: RAISE FND_API.G_EXC_ERROR;

145: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
146: FND_MESSAGE.SET_NAME('CN', 'CN_INVALID_ORG');
147: FND_MSG_PUB.ADD;
148: END IF;
149: RAISE FND_API.G_EXC_ERROR;
150: END IF;
151: EXCEPTION
152: WHEN NO_DATA_FOUND THEN
153: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 157: RAISE FND_API.G_EXC_ERROR;

153: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
154: FND_MESSAGE.SET_NAME('CN', 'CN_INVALID_ORG');
155: FND_MSG_PUB.ADD;
156: END IF;
157: RAISE FND_API.G_EXC_ERROR;
158: END ;
159:
160:
161: OPEN get_trans_src_cr;

Line 169: RAISE FND_API.G_EXC_ERROR ;

165: FND_MESSAGE.SET_NAME ('CN','CN_SCA_NO_ROWS_TO_PROCESS');
166: FND_MSG_PUB.Add;
167: END IF;
168: CLOSE get_trans_src_cr;
169: RAISE FND_API.G_EXC_ERROR ;
170: END IF;
171: CLOSE get_trans_src_cr;
172:
173: -- Construct the name of the dynamic package to be called to get the

Line 187: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

183: EXECUTE IMMEDIATE l_stmt USING IN x_batch_id ,IN p_org_id, OUT x_return_status,OUT x_msg_count,OUT x_msg_data;
184:
185: --dbms_output.put_line('status is INTERNAL '||x_return_status||' '||x_msg_data);
186:
187: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
188: RETURN;
189: END IF;
190:
191: l_stmt :=

Line 382: WHEN FND_API.G_EXC_ERROR THEN

378: END IF;
379:
380:
381: EXCEPTION
382: WHEN FND_API.G_EXC_ERROR THEN
383: x_return_status := FND_API.G_RET_STS_ERROR ;
384: FND_MSG_PUB.Count_And_Get
385: (p_count => x_msg_count ,
386: p_data => x_msg_data ,

Line 383: x_return_status := FND_API.G_RET_STS_ERROR ;

379:
380:
381: EXCEPTION
382: WHEN FND_API.G_EXC_ERROR THEN
383: x_return_status := FND_API.G_RET_STS_ERROR ;
384: FND_MSG_PUB.Count_And_Get
385: (p_count => x_msg_count ,
386: p_data => x_msg_data ,
387: p_encoded => FND_API.G_FALSE

Line 387: p_encoded => FND_API.G_FALSE

383: x_return_status := FND_API.G_RET_STS_ERROR ;
384: FND_MSG_PUB.Count_And_Get
385: (p_count => x_msg_count ,
386: p_data => x_msg_data ,
387: p_encoded => FND_API.G_FALSE
388: );
389: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
390: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
391: FND_MSG_PUB.Count_And_Get

Line 389: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

385: (p_count => x_msg_count ,
386: p_data => x_msg_data ,
387: p_encoded => FND_API.G_FALSE
388: );
389: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
390: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
391: FND_MSG_PUB.Count_And_Get
392: (p_count => x_msg_count ,
393: p_data => x_msg_data ,

Line 390: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

386: p_data => x_msg_data ,
387: p_encoded => FND_API.G_FALSE
388: );
389: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
390: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
391: FND_MSG_PUB.Count_And_Get
392: (p_count => x_msg_count ,
393: p_data => x_msg_data ,
394: p_encoded => FND_API.G_FALSE

Line 394: p_encoded => FND_API.G_FALSE

390: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
391: FND_MSG_PUB.Count_And_Get
392: (p_count => x_msg_count ,
393: p_data => x_msg_data ,
394: p_encoded => FND_API.G_FALSE
395: );
396: WHEN OTHERS THEN
397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
398: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

393: p_data => x_msg_data ,
394: p_encoded => FND_API.G_FALSE
395: );
396: WHEN OTHERS THEN
397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
398: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
399: THEN
400: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
401: END IF;

Line 405: p_encoded => FND_API.G_FALSE

401: END IF;
402: FND_MSG_PUB.Count_And_Get
403: (p_count => x_msg_count ,
404: p_data => x_msg_data ,
405: p_encoded => FND_API.G_FALSE
406: );
407:
408: END get_sales_credits;
409: END cn_sca_credits_online_pub;