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

Line 9: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

5: G_PKG_NAME CONSTANT VARCHAR2(30):='ICX_CAT_R12_UPGRADE_GRP';
6:
7: PROCEDURE updatePOHeaderId
8: ( p_api_version IN NUMBER ,
9: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
10: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
11: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
12: x_return_status OUT NOCOPY VARCHAR2 ,
13: p_interface_header_id IN DBMS_SQL.NUMBER_TABLE

Line 10: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

6:
7: PROCEDURE updatePOHeaderId
8: ( p_api_version IN NUMBER ,
9: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
10: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
11: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
12: x_return_status OUT NOCOPY VARCHAR2 ,
13: p_interface_header_id IN DBMS_SQL.NUMBER_TABLE
14: )

Line 11: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,

7: PROCEDURE updatePOHeaderId
8: ( p_api_version IN NUMBER ,
9: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
10: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
11: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
12: x_return_status OUT NOCOPY VARCHAR2 ,
13: p_interface_header_id IN DBMS_SQL.NUMBER_TABLE
14: )
15: IS

Line 22: x_return_status := FND_API.G_RET_STS_SUCCESS;

18: l_err_loc PLS_INTEGER;
19:
20: BEGIN
21: l_err_loc := 100;
22: x_return_status := FND_API.G_RET_STS_SUCCESS;
23:
24: l_err_loc := 200;
25: -- Standard Start of API savepoint
26: SAVEPOINT updatePOHeaderId_sp;

Line 30: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

26: SAVEPOINT updatePOHeaderId_sp;
27:
28: l_err_loc := 300;
29: -- Standard call to check for call compatibility.
30: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
31: p_api_version ,
32: l_api_name ,
33: G_PKG_NAME )
34: THEN

Line 36: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

32: l_api_name ,
33: G_PKG_NAME )
34: THEN
35: l_err_loc := 400;
36: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
37: END IF;
38:
39: l_err_loc := 500;
40: ICX_CAT_UTIL_PVT.setCommitParameter(p_commit);

Line 46: IF FND_API.To_Boolean( p_commit ) THEN

42: l_err_loc := 600;
43: ICX_CAT_R12_UPGRADE_PVT.updatePOHeaderId(p_interface_header_id);
44:
45: -- Standard check of p_commit
46: IF FND_API.To_Boolean( p_commit ) THEN
47: l_err_loc := 700;
48: COMMIT;
49: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
50: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

Line 77: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

73: END IF;
74: NULL;
75: END;
76: raise;
77: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
78: END updatePOHeaderId;
79:
80: PROCEDURE updatePOLineId
81: ( p_api_version IN NUMBER ,

Line 82: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

78: END updatePOHeaderId;
79:
80: PROCEDURE updatePOLineId
81: ( p_api_version IN NUMBER ,
82: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
83: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
84: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
85: x_return_status OUT NOCOPY VARCHAR2 ,
86: p_interface_line_id IN DBMS_SQL.NUMBER_TABLE

Line 83: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

79:
80: PROCEDURE updatePOLineId
81: ( p_api_version IN NUMBER ,
82: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
83: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
84: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
85: x_return_status OUT NOCOPY VARCHAR2 ,
86: p_interface_line_id IN DBMS_SQL.NUMBER_TABLE
87: )

Line 84: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,

80: PROCEDURE updatePOLineId
81: ( p_api_version IN NUMBER ,
82: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
83: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
84: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
85: x_return_status OUT NOCOPY VARCHAR2 ,
86: p_interface_line_id IN DBMS_SQL.NUMBER_TABLE
87: )
88: IS

Line 95: x_return_status := FND_API.G_RET_STS_SUCCESS;

91: l_err_loc PLS_INTEGER;
92:
93: BEGIN
94: l_err_loc := 100;
95: x_return_status := FND_API.G_RET_STS_SUCCESS;
96:
97: l_err_loc := 200;
98: -- Standard Start of API savepoint
99: SAVEPOINT updatePOLineId_sp;

Line 103: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

99: SAVEPOINT updatePOLineId_sp;
100:
101: l_err_loc := 300;
102: -- Standard call to check for call compatibility.
103: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
104: p_api_version ,
105: l_api_name ,
106: G_PKG_NAME )
107: THEN

Line 109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

105: l_api_name ,
106: G_PKG_NAME )
107: THEN
108: l_err_loc := 400;
109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
110: END IF;
111:
112: l_err_loc := 500;
113: ICX_CAT_UTIL_PVT.setCommitParameter(p_commit);

Line 120: IF FND_API.To_Boolean( p_commit ) THEN

116: ICX_CAT_R12_UPGRADE_PVT.updatePOLineId(p_interface_line_id);
117:
118: l_err_loc := 700;
119: -- Standard check of p_commit
120: IF FND_API.To_Boolean( p_commit ) THEN
121: l_err_loc := 800;
122: COMMIT;
123: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
124: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

Line 151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

147: END IF;
148: NULL;
149: END;
150: raise;
151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
152: END updatePOLineId;
153:
154: -- Start of comments
155: -- API name : createR12UpgradeJob

Line 162: -- Default = FND_API.G_TRUE

158: -- * Function : inserts a job in icx_cat_r12_upgrade_jobs
159: -- * Parameters :
160: -- IN : p_api_version IN NUMBER Required
161: -- p_commit IN VARCHAR2 Optional
162: -- Default = FND_API.G_TRUE
163: -- p_init_msg_list IN VARCHAR2 Optional
164: -- Default = FND_API.G_FALSE
165: -- p_validation_level IN NUMBER Optional
166: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 164: -- Default = FND_API.G_FALSE

160: -- IN : p_api_version IN NUMBER Required
161: -- p_commit IN VARCHAR2 Optional
162: -- Default = FND_API.G_TRUE
163: -- p_init_msg_list IN VARCHAR2 Optional
164: -- Default = FND_API.G_FALSE
165: -- p_validation_level IN NUMBER Optional
166: -- Default = FND_API.G_VALID_LEVEL_FULL
167: -- p_job_type IN VARCHAR2 Required
168: -- Type of job to be created

Line 166: -- Default = FND_API.G_VALID_LEVEL_FULL

162: -- Default = FND_API.G_TRUE
163: -- p_init_msg_list IN VARCHAR2 Optional
164: -- Default = FND_API.G_FALSE
165: -- p_validation_level IN NUMBER Optional
166: -- Default = FND_API.G_VALID_LEVEL_FULL
167: -- p_job_type IN VARCHAR2 Required
168: -- Type of job to be created
169: -- p_audsid IN NUMBER Required
170: -- audsid for the job to be created

Line 181: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

177: --
178: -- End of comments
179: PROCEDURE createR12UpgradeJob
180: ( p_api_version IN NUMBER ,
181: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
182: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
183: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
184: x_return_status OUT NOCOPY VARCHAR2 ,
185: p_job_type IN VARCHAR2,

Line 182: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

178: -- End of comments
179: PROCEDURE createR12UpgradeJob
180: ( p_api_version IN NUMBER ,
181: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
182: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
183: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
184: x_return_status OUT NOCOPY VARCHAR2 ,
185: p_job_type IN VARCHAR2,
186: p_audsid IN NUMBER

Line 183: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,

179: PROCEDURE createR12UpgradeJob
180: ( p_api_version IN NUMBER ,
181: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
182: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
183: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
184: x_return_status OUT NOCOPY VARCHAR2 ,
185: p_job_type IN VARCHAR2,
186: p_audsid IN NUMBER
187: )

Line 198: x_return_status := FND_API.G_RET_STS_SUCCESS;

194:
195:
196: BEGIN
197: l_err_loc := 100;
198: x_return_status := FND_API.G_RET_STS_SUCCESS;
199:
200: l_err_loc := 200;
201: -- Standard Start of API savepoint
202: SAVEPOINT createR12UpgradeJob_sp;

Line 206: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

202: SAVEPOINT createR12UpgradeJob_sp;
203:
204: l_err_loc := 300;
205: -- Standard call to check for call compatibility.
206: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
207: p_api_version ,
208: l_api_name ,
209: G_PKG_NAME )
210: THEN

Line 212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

208: l_api_name ,
209: G_PKG_NAME )
210: THEN
211: l_err_loc := 400;
212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
213: END IF;
214:
215: l_err_loc := 500;
216: ICX_CAT_UTIL_PVT.setCommitParameter(p_commit);

Line 249: IF FND_API.To_Boolean( p_commit ) THEN

245: ICX_CAT_R12_UPGRADE_PVT.createR12UpgradeJob(p_audsid);
246:
247: l_err_loc := 700;
248: -- Standard check of p_commit
249: IF FND_API.To_Boolean( p_commit ) THEN
250: l_err_loc := 800;
251: COMMIT;
252: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
253: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

Line 281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

277: END IF;
278: NULL;
279: END;
280: raise;
281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
282: END createR12UpgradeJob;
283:
284: -- Start of comments
285: -- API name : updateR12UpgradeJob

Line 292: -- Default = FND_API.G_TRUE

288: -- * Function : updates a job in icx_cat_r12_upgrade_jobs
289: -- * Parameters :
290: -- IN : p_api_version IN NUMBER Required
291: -- p_commit IN VARCHAR2 Optional
292: -- Default = FND_API.G_TRUE
293: -- p_init_msg_list IN VARCHAR2 Optional
294: -- Default = FND_API.G_FALSE
295: -- p_validation_level IN NUMBER Optional
296: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 294: -- Default = FND_API.G_FALSE

290: -- IN : p_api_version IN NUMBER Required
291: -- p_commit IN VARCHAR2 Optional
292: -- Default = FND_API.G_TRUE
293: -- p_init_msg_list IN VARCHAR2 Optional
294: -- Default = FND_API.G_FALSE
295: -- p_validation_level IN NUMBER Optional
296: -- Default = FND_API.G_VALID_LEVEL_FULL
297: -- p_job_status IN VARCHAR2 Required
298: -- New status of the job

Line 296: -- Default = FND_API.G_VALID_LEVEL_FULL

292: -- Default = FND_API.G_TRUE
293: -- p_init_msg_list IN VARCHAR2 Optional
294: -- Default = FND_API.G_FALSE
295: -- p_validation_level IN NUMBER Optional
296: -- Default = FND_API.G_VALID_LEVEL_FULL
297: -- p_job_status IN VARCHAR2 Required
298: -- New status of the job
299: -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
300: -- * Version : Current version 1.0

Line 309: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

305: --
306: -- End of comments
307: PROCEDURE updateR12UpgradeJob
308: ( p_api_version IN NUMBER ,
309: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
310: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
311: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
312: x_return_status OUT NOCOPY VARCHAR2 ,
313: p_job_status IN VARCHAR2

Line 310: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

306: -- End of comments
307: PROCEDURE updateR12UpgradeJob
308: ( p_api_version IN NUMBER ,
309: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
310: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
311: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
312: x_return_status OUT NOCOPY VARCHAR2 ,
313: p_job_status IN VARCHAR2
314: )

Line 311: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,

307: PROCEDURE updateR12UpgradeJob
308: ( p_api_version IN NUMBER ,
309: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
310: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
311: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
312: x_return_status OUT NOCOPY VARCHAR2 ,
313: p_job_status IN VARCHAR2
314: )
315: IS

Line 323: x_return_status := FND_API.G_RET_STS_SUCCESS;

319: l_err_loc PLS_INTEGER;
320:
321: BEGIN
322: l_err_loc := 100;
323: x_return_status := FND_API.G_RET_STS_SUCCESS;
324:
325: l_err_loc := 200;
326: -- Standard Start of API savepoint
327: SAVEPOINT updateR12UpgradeJob_sp;

Line 331: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

327: SAVEPOINT updateR12UpgradeJob_sp;
328:
329: l_err_loc := 300;
330: -- Standard call to check for call compatibility.
331: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
332: p_api_version ,
333: l_api_name ,
334: G_PKG_NAME )
335: THEN

Line 337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

333: l_api_name ,
334: G_PKG_NAME )
335: THEN
336: l_err_loc := 400;
337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
338: END IF;
339:
340: l_err_loc := 500;
341: ICX_CAT_UTIL_PVT.setCommitParameter(p_commit);

Line 364: IF FND_API.To_Boolean( p_commit ) THEN

360: ICX_CAT_R12_UPGRADE_PVT.updateR12UpgradeJob(p_job_status);
361:
362: l_err_loc := 700;
363: -- Standard check of p_commit
364: IF FND_API.To_Boolean( p_commit ) THEN
365: l_err_loc := 800;
366: COMMIT;
367: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
368: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

Line 396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

392: END IF;
393: NULL;
394: END;
395: raise;
396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
397: END updateR12UpgradeJob;
398:
399:
400: END ICX_CAT_R12_UPGRADE_GRP;