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

Line 58: x_return_status := FND_API.G_RET_STS_SUCCESS;

54: and ENABLED_FLAG = 'Y';
55:
56: BEGIN
57: -- Initialize API return status to success
58: x_return_status := FND_API.G_RET_STS_SUCCESS;
59:
60: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
61: aso_debug_pub.add('Validate_Template: p_template_context :'||p_template_context, 1, 'N');
62: aso_debug_pub.add('Validate_Template: p_template_level :'||p_template_level, 1, 'N');

Line 77: x_return_status := FND_API.G_RET_STS_ERROR;

73: FND_MESSAGE.Set_Token ('COLUMN' , 'TEMPLATE CONTEXT', FALSE );
74: FND_MESSAGE.Set_Token ('VALUE' ,p_template_context, FALSE );
75: FND_MSG_PUB.ADD;
76: END IF;
77: x_return_status := FND_API.G_RET_STS_ERROR;
78: RETURN x_return_status;
79: END IF;
80:
81: CLOSE c_template_context;

Line 96: x_return_status := FND_API.G_RET_STS_ERROR;

92: FND_MESSAGE.Set_Token ('COLUMN' , 'TEMPLATE LEVEL', FALSE );
93: FND_MESSAGE.Set_Token ('VALUE' ,p_template_level, FALSE );
94: FND_MSG_PUB.ADD;
95: END IF;
96: x_return_status := FND_API.G_RET_STS_ERROR;
97: RETURN x_return_status;
98:
99: END IF;
100:

Line 114: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

110:
111: PROCEDURE CREATE_TEMPLATE
112: (
113: P_Api_Version_Number IN NUMBER,
114: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
115: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
116: P_TEMPLATE_REC IN ASO_SUP_TEMPLATE_DATA_PVT.TEMPLATE_REC_TYPE,
117: X_Template_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
118: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 115: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

111: PROCEDURE CREATE_TEMPLATE
112: (
113: P_Api_Version_Number IN NUMBER,
114: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
115: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
116: P_TEMPLATE_REC IN ASO_SUP_TEMPLATE_DATA_PVT.TEMPLATE_REC_TYPE,
117: X_Template_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
118: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
119: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 137: IF NOT FND_API.Compatible_API_Call (

133: -- Establish a standard save point
134: SAVEPOINT CREATE_TEMPLATE_PVT;
135:
136: -- Standard call to check for call compatability
137: IF NOT FND_API.Compatible_API_Call (
138: l_api_version_number
139: , p_api_version_number
140: , l_api_name
141: , G_PKG_NAME

Line 143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

139: , p_api_version_number
140: , l_api_name
141: , G_PKG_NAME
142: ) THEN
143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
144: END IF;
145:
146: -- Initialize message list if p_init_msg_list is set to TRUE.
147: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 147: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
144: END IF;
145:
146: -- Initialize message list if p_init_msg_list is set to TRUE.
147: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
148: FND_MSG_PUB.initialize;
149: END IF;
150:
151:

Line 153: x_return_status := FND_API.G_RET_STS_SUCCESS;

149: END IF;
150:
151:
152: -- Initialize API return status to success
153: x_return_status := FND_API.G_RET_STS_SUCCESS;
154:
155: -- API BODY
156: IF aso_debug_pub.g_debug_flag = 'Y' THEN
157: aso_debug_pub.ADD ('CREATE_TEMPLATE : Begin' , 1, 'N' );

Line 167: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

163: Validate_Template(
164: p_template_context =>P_TEMPLATE_REC.TEMPLATE_CONTEXT,
165: p_template_level => P_TEMPLATE_REC.TEMPLATE_LEVEL);
166:
167: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
168: x_return_status := l_return_status;
169: RAISE FND_API.G_EXC_ERROR;
170: END IF;
171:

Line 169: RAISE FND_API.G_EXC_ERROR;

165: p_template_level => P_TEMPLATE_REC.TEMPLATE_LEVEL);
166:
167: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
168: x_return_status := l_return_status;
169: RAISE FND_API.G_EXC_ERROR;
170: END IF;
171:
172: ASO_SUP_TEMPLATE_PKG.INSERT_ROW (
173: PX_ROWID => row_id,

Line 211: IF FND_API.to_Boolean ( p_commit ) THEN

207: X_Template_id := l_template_id;
208:
209:
210: -- Standard check for p_commit
211: IF FND_API.to_Boolean ( p_commit ) THEN
212: COMMIT WORK;
213: END IF;
214:
215:

Line 222: WHEN FND_API.G_EXC_ERROR THEN

218: END IF;
219:
220: EXCEPTION
221:
222: WHEN FND_API.G_EXC_ERROR THEN
223: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
224: P_API_NAME => L_API_NAME
225: , P_PKG_NAME => G_PKG_NAME
226: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 233: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

229: , X_MSG_DATA => X_MSG_DATA
230: , X_RETURN_STATUS => X_RETURN_STATUS
231: );
232:
233: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
234: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
235: P_API_NAME => L_API_NAME
236: , P_PKG_NAME => G_PKG_NAME
237: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 263: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

259:
260: PROCEDURE Update_Template
261: (
262: P_Api_Version_Number IN NUMBER,
263: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
264: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
265: P_TEMPLATE_REC IN ASO_SUP_TEMPLATE_DATA_PVT.TEMPLATE_REC_TYPE,
266: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
267: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 264: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

260: PROCEDURE Update_Template
261: (
262: P_Api_Version_Number IN NUMBER,
263: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
264: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
265: P_TEMPLATE_REC IN ASO_SUP_TEMPLATE_DATA_PVT.TEMPLATE_REC_TYPE,
266: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
267: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
268: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 )

Line 283: IF NOT FND_API.Compatible_API_Call (

279: -- Establish a standard save point
280: SAVEPOINT UPDATE_TEMPLATE_PVT;
281:
282: -- Standard call to check for call compatability
283: IF NOT FND_API.Compatible_API_Call (
284: l_api_version_number
285: , p_api_version_number
286: , l_api_name
287: , G_PKG_NAME

Line 289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

285: , p_api_version_number
286: , l_api_name
287: , G_PKG_NAME
288: ) THEN
289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
290: END IF;
291:
292: -- Initialize message list if p_init_msg_list is set to TRUE.
293: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 293: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
290: END IF;
291:
292: -- Initialize message list if p_init_msg_list is set to TRUE.
293: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
294: FND_MSG_PUB.initialize;
295: END IF;
296:
297:

Line 299: x_return_status := FND_API.G_RET_STS_SUCCESS;

295: END IF;
296:
297:
298: -- Initialize API return status to success
299: x_return_status := FND_API.G_RET_STS_SUCCESS;
300:
301: -- API BODY
302: IF aso_debug_pub.g_debug_flag = 'Y' THEN
303: aso_debug_pub.ADD ('UPDATE_TEMPLATE : Begin' , 1, 'N' );

Line 313: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

309: Validate_Template(
310: p_template_context =>P_TEMPLATE_REC.TEMPLATE_CONTEXT,
311: p_template_level => P_TEMPLATE_REC.TEMPLATE_LEVEL);
312:
313: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
314: x_return_status := l_return_status;
315: RAISE FND_API.G_EXC_ERROR;
316: END IF;
317:

Line 315: RAISE FND_API.G_EXC_ERROR;

311: p_template_level => P_TEMPLATE_REC.TEMPLATE_LEVEL);
312:
313: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
314: x_return_status := l_return_status;
315: RAISE FND_API.G_EXC_ERROR;
316: END IF;
317:
318:
319: ASO_SUP_TEMPLATE_PKG.UPDATE_ROW (

Line 353: IF FND_API.to_Boolean ( p_commit ) THEN

349: );
350:
351:
352: -- Standard check for p_commit
353: IF FND_API.to_Boolean ( p_commit ) THEN
354: COMMIT WORK;
355: END IF;
356:
357:

Line 364: WHEN FND_API.G_EXC_ERROR THEN

360: END IF;
361:
362: EXCEPTION
363:
364: WHEN FND_API.G_EXC_ERROR THEN
365: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
366: P_API_NAME => L_API_NAME
367: , P_PKG_NAME => G_PKG_NAME
368: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

371: , X_MSG_DATA => X_MSG_DATA
372: , X_RETURN_STATUS => X_RETURN_STATUS
373: );
374:
375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
376: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
377: P_API_NAME => L_API_NAME
378: , P_PKG_NAME => G_PKG_NAME
379: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR