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

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

40: END; */
41: --
42: PROCEDURE insert_row(
43: p_api_version IN NUMBER,
44: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
45: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
46: p_commit IN VARCHAR2 := CN_API.G_FALSE,
47: p_reasons_all_rec IN CN_REASONS_PKG.REASONS_ALL_REC_TYPE,
48: x_return_status OUT NOCOPY VARCHAR2,

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

41: --
42: PROCEDURE insert_row(
43: p_api_version IN NUMBER,
44: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
45: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
46: p_commit IN VARCHAR2 := CN_API.G_FALSE,
47: p_reasons_all_rec IN CN_REASONS_PKG.REASONS_ALL_REC_TYPE,
48: x_return_status OUT NOCOPY VARCHAR2,
49: x_msg_count OUT NOCOPY NUMBER,

Line 61: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

57: BEGIN
58: -- Standard Start of API savepoint
59: SAVEPOINT insert_row;
60: -- Standard call to check for call compatibility.
61: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
62: p_api_version ,
63: l_api_name,
64: G_PKG_NAME ) THEN
65: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 65: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

61: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
62: p_api_version ,
63: l_api_name,
64: G_PKG_NAME ) THEN
65: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
66: END IF;
67: -- Initialize message list if p_init_msg_list is set to TRUE.
68: IF FND_API.to_Boolean( p_init_msg_list ) THEN
69: FND_MSG_PUB.initialize;

Line 68: IF FND_API.to_Boolean( p_init_msg_list ) THEN

64: G_PKG_NAME ) THEN
65: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
66: END IF;
67: -- Initialize message list if p_init_msg_list is set to TRUE.
68: IF FND_API.to_Boolean( p_init_msg_list ) THEN
69: FND_MSG_PUB.initialize;
70: END IF;
71: -- Initialize API return status to success
72: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 72: x_return_status := FND_API.G_RET_STS_SUCCESS;

68: IF FND_API.to_Boolean( p_init_msg_list ) THEN
69: FND_MSG_PUB.initialize;
70: END IF;
71: -- Initialize API return status to success
72: x_return_status := FND_API.G_RET_STS_SUCCESS;
73: x_loading_status := 'CN_INSERTED';
74: -- API body
75: l_reasons_all_rec := p_reasons_all_rec;
76: --

Line 83: RAISE FND_API.G_EXC_ERROR;

79: INTO l_reasons_all_rec.reason_id
80: FROM DUAL;
81: EXCEPTION
82: WHEN OTHERS THEN
83: RAISE FND_API.G_EXC_ERROR;
84: END;
85: IF ((l_reasons_all_rec.reason_code = fnd_api.g_miss_char) OR
86: (l_reasons_all_rec.reason = fnd_api.g_miss_char) OR
87: (l_reasons_all_rec.lookup_type = fnd_api.g_miss_char) OR

Line 85: IF ((l_reasons_all_rec.reason_code = fnd_api.g_miss_char) OR

81: EXCEPTION
82: WHEN OTHERS THEN
83: RAISE FND_API.G_EXC_ERROR;
84: END;
85: IF ((l_reasons_all_rec.reason_code = fnd_api.g_miss_char) OR
86: (l_reasons_all_rec.reason = fnd_api.g_miss_char) OR
87: (l_reasons_all_rec.lookup_type = fnd_api.g_miss_char) OR
88: (l_reasons_all_rec.updated_table = fnd_api.g_miss_char) OR
89: (l_reasons_all_rec.upd_table_id = fnd_api.g_miss_num)) THEN

Line 86: (l_reasons_all_rec.reason = fnd_api.g_miss_char) OR

82: WHEN OTHERS THEN
83: RAISE FND_API.G_EXC_ERROR;
84: END;
85: IF ((l_reasons_all_rec.reason_code = fnd_api.g_miss_char) OR
86: (l_reasons_all_rec.reason = fnd_api.g_miss_char) OR
87: (l_reasons_all_rec.lookup_type = fnd_api.g_miss_char) OR
88: (l_reasons_all_rec.updated_table = fnd_api.g_miss_char) OR
89: (l_reasons_all_rec.upd_table_id = fnd_api.g_miss_num)) THEN
90: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 87: (l_reasons_all_rec.lookup_type = fnd_api.g_miss_char) OR

83: RAISE FND_API.G_EXC_ERROR;
84: END;
85: IF ((l_reasons_all_rec.reason_code = fnd_api.g_miss_char) OR
86: (l_reasons_all_rec.reason = fnd_api.g_miss_char) OR
87: (l_reasons_all_rec.lookup_type = fnd_api.g_miss_char) OR
88: (l_reasons_all_rec.updated_table = fnd_api.g_miss_char) OR
89: (l_reasons_all_rec.upd_table_id = fnd_api.g_miss_num)) THEN
90: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
91: FND_MESSAGE.SET_NAME ('CN' , 'CN_REQUIRED_FIELDS');

Line 88: (l_reasons_all_rec.updated_table = fnd_api.g_miss_char) OR

84: END;
85: IF ((l_reasons_all_rec.reason_code = fnd_api.g_miss_char) OR
86: (l_reasons_all_rec.reason = fnd_api.g_miss_char) OR
87: (l_reasons_all_rec.lookup_type = fnd_api.g_miss_char) OR
88: (l_reasons_all_rec.updated_table = fnd_api.g_miss_char) OR
89: (l_reasons_all_rec.upd_table_id = fnd_api.g_miss_num)) THEN
90: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
91: FND_MESSAGE.SET_NAME ('CN' , 'CN_REQUIRED_FIELDS');
92: FND_MSG_PUB.Add;

Line 89: (l_reasons_all_rec.upd_table_id = fnd_api.g_miss_num)) THEN

85: IF ((l_reasons_all_rec.reason_code = fnd_api.g_miss_char) OR
86: (l_reasons_all_rec.reason = fnd_api.g_miss_char) OR
87: (l_reasons_all_rec.lookup_type = fnd_api.g_miss_char) OR
88: (l_reasons_all_rec.updated_table = fnd_api.g_miss_char) OR
89: (l_reasons_all_rec.upd_table_id = fnd_api.g_miss_num)) THEN
90: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
91: FND_MESSAGE.SET_NAME ('CN' , 'CN_REQUIRED_FIELDS');
92: FND_MSG_PUB.Add;
93: END IF;

Line 95: RAISE FND_API.G_EXC_ERROR;

91: FND_MESSAGE.SET_NAME ('CN' , 'CN_REQUIRED_FIELDS');
92: FND_MSG_PUB.Add;
93: END IF;
94: x_loading_status := 'CN_REQUIRED_FIELDS';
95: RAISE FND_API.G_EXC_ERROR;
96: ELSE
97: cn_reasons_pkg.insert_row(l_reasons_all_rec);
98: END IF;
99: EXCEPTION

Line 100: WHEN FND_API.G_EXC_ERROR THEN

96: ELSE
97: cn_reasons_pkg.insert_row(l_reasons_all_rec);
98: END IF;
99: EXCEPTION
100: WHEN FND_API.G_EXC_ERROR THEN
101: ROLLBACK TO insert_row;
102: x_return_status := FND_API.G_RET_STS_ERROR ;
103: FND_MSG_PUB.Count_And_Get(
104: p_count => x_msg_count ,

Line 102: x_return_status := FND_API.G_RET_STS_ERROR ;

98: END IF;
99: EXCEPTION
100: WHEN FND_API.G_EXC_ERROR THEN
101: ROLLBACK TO insert_row;
102: x_return_status := FND_API.G_RET_STS_ERROR ;
103: FND_MSG_PUB.Count_And_Get(
104: p_count => x_msg_count ,
105: p_data => x_msg_data ,
106: p_encoded => FND_API.G_FALSE);

Line 106: p_encoded => FND_API.G_FALSE);

102: x_return_status := FND_API.G_RET_STS_ERROR ;
103: FND_MSG_PUB.Count_And_Get(
104: p_count => x_msg_count ,
105: p_data => x_msg_data ,
106: p_encoded => FND_API.G_FALSE);
107: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
108: ROLLBACK TO insert_row;
109: x_loading_status := 'UNEXPECTED_ERR';
110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 107: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

103: FND_MSG_PUB.Count_And_Get(
104: p_count => x_msg_count ,
105: p_data => x_msg_data ,
106: p_encoded => FND_API.G_FALSE);
107: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
108: ROLLBACK TO insert_row;
109: x_loading_status := 'UNEXPECTED_ERR';
110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
111: FND_MSG_PUB.Count_And_Get(

Line 110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

106: p_encoded => FND_API.G_FALSE);
107: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
108: ROLLBACK TO insert_row;
109: x_loading_status := 'UNEXPECTED_ERR';
110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
111: FND_MSG_PUB.Count_And_Get(
112: p_count => x_msg_count ,
113: p_data => x_msg_data ,
114: p_encoded => FND_API.G_FALSE);

Line 114: p_encoded => FND_API.G_FALSE);

110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
111: FND_MSG_PUB.Count_And_Get(
112: p_count => x_msg_count ,
113: p_data => x_msg_data ,
114: p_encoded => FND_API.G_FALSE);
115: WHEN OTHERS THEN
116: ROLLBACK TO insert_row;
117: x_loading_status := 'UNEXPECTED_ERR';
118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

114: p_encoded => FND_API.G_FALSE);
115: WHEN OTHERS THEN
116: ROLLBACK TO insert_row;
117: x_loading_status := 'UNEXPECTED_ERR';
118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
119: IF FND_MSG_PUB.Check_Msg_Level(
120: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
121: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
122: END IF;

Line 126: p_encoded => FND_API.G_FALSE);

122: END IF;
123: FND_MSG_PUB.Count_And_Get(
124: p_count => x_msg_count ,
125: p_data => x_msg_data ,
126: p_encoded => FND_API.G_FALSE);
127: END;
128: --
129: PROCEDURE update_row(
130: p_api_version IN NUMBER,

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

127: END;
128: --
129: PROCEDURE update_row(
130: p_api_version IN NUMBER,
131: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
132: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
133: p_commit IN VARCHAR2 := CN_API.G_FALSE,
134: p_reasons_all_rec IN CN_REASONS_PKG.REASONS_ALL_REC_TYPE,
135: x_return_status OUT NOCOPY VARCHAR2,

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

128: --
129: PROCEDURE update_row(
130: p_api_version IN NUMBER,
131: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
132: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
133: p_commit IN VARCHAR2 := CN_API.G_FALSE,
134: p_reasons_all_rec IN CN_REASONS_PKG.REASONS_ALL_REC_TYPE,
135: x_return_status OUT NOCOPY VARCHAR2,
136: x_msg_count OUT NOCOPY NUMBER,

Line 157: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

153: BEGIN
154: -- Standard Start of API savepoint
155: SAVEPOINT update_row;
156: -- Standard call to check for call compatibility.
157: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
158: p_api_version ,
159: l_api_name,
160: G_PKG_NAME ) THEN
161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

157: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
158: p_api_version ,
159: l_api_name,
160: G_PKG_NAME ) THEN
161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
162: END IF;
163: -- Initialize message list if p_init_msg_list is set to TRUE.
164: IF FND_API.to_Boolean( p_init_msg_list ) THEN
165: FND_MSG_PUB.initialize;

Line 164: IF FND_API.to_Boolean( p_init_msg_list ) THEN

160: G_PKG_NAME ) THEN
161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
162: END IF;
163: -- Initialize message list if p_init_msg_list is set to TRUE.
164: IF FND_API.to_Boolean( p_init_msg_list ) THEN
165: FND_MSG_PUB.initialize;
166: END IF;
167: -- Initialize API return status to success
168: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 168: x_return_status := FND_API.G_RET_STS_SUCCESS;

164: IF FND_API.to_Boolean( p_init_msg_list ) THEN
165: FND_MSG_PUB.initialize;
166: END IF;
167: -- Initialize API return status to success
168: x_return_status := FND_API.G_RET_STS_SUCCESS;
169: x_loading_status := 'CN_INSERTED';
170: -- API body
171: l_reasons_all_rec := p_reasons_all_rec;
172: --

Line 173: IF ((l_reasons_all_rec.reason_code = fnd_api.g_miss_char) OR

169: x_loading_status := 'CN_INSERTED';
170: -- API body
171: l_reasons_all_rec := p_reasons_all_rec;
172: --
173: IF ((l_reasons_all_rec.reason_code = fnd_api.g_miss_char) OR
174: (l_reasons_all_rec.reason = fnd_api.g_miss_char) OR
175: (l_reasons_all_rec.lookup_type = fnd_api.g_miss_char) OR
176: (l_reasons_all_rec.updated_table = fnd_api.g_miss_char) OR
177: (l_reasons_all_rec.upd_table_id = fnd_api.g_miss_num)) THEN

Line 174: (l_reasons_all_rec.reason = fnd_api.g_miss_char) OR

170: -- API body
171: l_reasons_all_rec := p_reasons_all_rec;
172: --
173: IF ((l_reasons_all_rec.reason_code = fnd_api.g_miss_char) OR
174: (l_reasons_all_rec.reason = fnd_api.g_miss_char) OR
175: (l_reasons_all_rec.lookup_type = fnd_api.g_miss_char) OR
176: (l_reasons_all_rec.updated_table = fnd_api.g_miss_char) OR
177: (l_reasons_all_rec.upd_table_id = fnd_api.g_miss_num)) THEN
178: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 175: (l_reasons_all_rec.lookup_type = fnd_api.g_miss_char) OR

171: l_reasons_all_rec := p_reasons_all_rec;
172: --
173: IF ((l_reasons_all_rec.reason_code = fnd_api.g_miss_char) OR
174: (l_reasons_all_rec.reason = fnd_api.g_miss_char) OR
175: (l_reasons_all_rec.lookup_type = fnd_api.g_miss_char) OR
176: (l_reasons_all_rec.updated_table = fnd_api.g_miss_char) OR
177: (l_reasons_all_rec.upd_table_id = fnd_api.g_miss_num)) THEN
178: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
179: FND_MESSAGE.SET_NAME ('CN' , 'CN_REQUIRED_FIELDS');

Line 176: (l_reasons_all_rec.updated_table = fnd_api.g_miss_char) OR

172: --
173: IF ((l_reasons_all_rec.reason_code = fnd_api.g_miss_char) OR
174: (l_reasons_all_rec.reason = fnd_api.g_miss_char) OR
175: (l_reasons_all_rec.lookup_type = fnd_api.g_miss_char) OR
176: (l_reasons_all_rec.updated_table = fnd_api.g_miss_char) OR
177: (l_reasons_all_rec.upd_table_id = fnd_api.g_miss_num)) THEN
178: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
179: FND_MESSAGE.SET_NAME ('CN' , 'CN_REQUIRED_FIELDS');
180: FND_MSG_PUB.Add;

Line 177: (l_reasons_all_rec.upd_table_id = fnd_api.g_miss_num)) THEN

173: IF ((l_reasons_all_rec.reason_code = fnd_api.g_miss_char) OR
174: (l_reasons_all_rec.reason = fnd_api.g_miss_char) OR
175: (l_reasons_all_rec.lookup_type = fnd_api.g_miss_char) OR
176: (l_reasons_all_rec.updated_table = fnd_api.g_miss_char) OR
177: (l_reasons_all_rec.upd_table_id = fnd_api.g_miss_num)) THEN
178: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
179: FND_MESSAGE.SET_NAME ('CN' , 'CN_REQUIRED_FIELDS');
180: FND_MSG_PUB.Add;
181: END IF;

Line 183: RAISE FND_API.G_EXC_ERROR;

179: FND_MESSAGE.SET_NAME ('CN' , 'CN_REQUIRED_FIELDS');
180: FND_MSG_PUB.Add;
181: END IF;
182: x_loading_status := 'CN_REQUIRED_FIELDS';
183: RAISE FND_API.G_EXC_ERROR;
184: ELSE
185: -- First original record to be moved to CN_REASON_HISTORY table.
186: FOR rec IN reason_cur(l_reasons_all_rec.reason_id)
187: LOOP

Line 228: WHEN FND_API.G_EXC_ERROR THEN

224: --
225: END LOOP;
226: END IF;
227: EXCEPTION
228: WHEN FND_API.G_EXC_ERROR THEN
229: ROLLBACK TO update_row;
230: x_return_status := FND_API.G_RET_STS_ERROR ;
231: FND_MSG_PUB.Count_And_Get(
232: p_count => x_msg_count ,

Line 230: x_return_status := FND_API.G_RET_STS_ERROR ;

226: END IF;
227: EXCEPTION
228: WHEN FND_API.G_EXC_ERROR THEN
229: ROLLBACK TO update_row;
230: x_return_status := FND_API.G_RET_STS_ERROR ;
231: FND_MSG_PUB.Count_And_Get(
232: p_count => x_msg_count ,
233: p_data => x_msg_data ,
234: p_encoded => FND_API.G_FALSE);

Line 234: p_encoded => FND_API.G_FALSE);

230: x_return_status := FND_API.G_RET_STS_ERROR ;
231: FND_MSG_PUB.Count_And_Get(
232: p_count => x_msg_count ,
233: p_data => x_msg_data ,
234: p_encoded => FND_API.G_FALSE);
235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
236: ROLLBACK TO update_row;
237: x_loading_status := 'UNEXPECTED_ERR';
238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

231: FND_MSG_PUB.Count_And_Get(
232: p_count => x_msg_count ,
233: p_data => x_msg_data ,
234: p_encoded => FND_API.G_FALSE);
235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
236: ROLLBACK TO update_row;
237: x_loading_status := 'UNEXPECTED_ERR';
238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
239: FND_MSG_PUB.Count_And_Get(

Line 238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

234: p_encoded => FND_API.G_FALSE);
235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
236: ROLLBACK TO update_row;
237: x_loading_status := 'UNEXPECTED_ERR';
238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
239: FND_MSG_PUB.Count_And_Get(
240: p_count => x_msg_count ,
241: p_data => x_msg_data ,
242: p_encoded => FND_API.G_FALSE);

Line 242: p_encoded => FND_API.G_FALSE);

238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
239: FND_MSG_PUB.Count_And_Get(
240: p_count => x_msg_count ,
241: p_data => x_msg_data ,
242: p_encoded => FND_API.G_FALSE);
243: WHEN OTHERS THEN
244: ROLLBACK TO update_row;
245: x_loading_status := 'UNEXPECTED_ERR';
246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

242: p_encoded => FND_API.G_FALSE);
243: WHEN OTHERS THEN
244: ROLLBACK TO update_row;
245: x_loading_status := 'UNEXPECTED_ERR';
246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
247: IF FND_MSG_PUB.Check_Msg_Level(
248: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
249: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
250: END IF;

Line 254: p_encoded => FND_API.G_FALSE);

250: END IF;
251: FND_MSG_PUB.Count_And_Get(
252: p_count => x_msg_count ,
253: p_data => x_msg_data ,
254: p_encoded => FND_API.G_FALSE);
255: END;
256: --
257: PROCEDURE delete_notes(
258: p_api_version IN NUMBER,

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

255: END;
256: --
257: PROCEDURE delete_notes(
258: p_api_version IN NUMBER,
259: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
260: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
261: p_commit IN VARCHAR2 := CN_API.G_FALSE,
262: p_reason_id IN NUMBER := FND_API.G_MISS_NUM,
263: x_return_status OUT NOCOPY VARCHAR2,

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

256: --
257: PROCEDURE delete_notes(
258: p_api_version IN NUMBER,
259: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
260: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
261: p_commit IN VARCHAR2 := CN_API.G_FALSE,
262: p_reason_id IN NUMBER := FND_API.G_MISS_NUM,
263: x_return_status OUT NOCOPY VARCHAR2,
264: x_msg_count OUT NOCOPY NUMBER,

Line 262: p_reason_id IN NUMBER := FND_API.G_MISS_NUM,

258: p_api_version IN NUMBER,
259: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
260: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
261: p_commit IN VARCHAR2 := CN_API.G_FALSE,
262: p_reason_id IN NUMBER := FND_API.G_MISS_NUM,
263: x_return_status OUT NOCOPY VARCHAR2,
264: x_msg_count OUT NOCOPY NUMBER,
265: x_msg_data OUT NOCOPY VARCHAR2,
266: x_loading_status OUT NOCOPY VARCHAR2) IS

Line 284: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

280: BEGIN
281: -- Standard Start of API savepoint
282: SAVEPOINT delete_notes;
283: -- Standard call to check for call compatibility.
284: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
285: p_api_version ,
286: l_api_name,
287: G_PKG_NAME ) THEN
288: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 288: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

284: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
285: p_api_version ,
286: l_api_name,
287: G_PKG_NAME ) THEN
288: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
289: END IF;
290: -- Initialize message list if p_init_msg_list is set to TRUE.
291: IF FND_API.to_Boolean( p_init_msg_list ) THEN
292: FND_MSG_PUB.initialize;

Line 291: IF FND_API.to_Boolean( p_init_msg_list ) THEN

287: G_PKG_NAME ) THEN
288: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
289: END IF;
290: -- Initialize message list if p_init_msg_list is set to TRUE.
291: IF FND_API.to_Boolean( p_init_msg_list ) THEN
292: FND_MSG_PUB.initialize;
293: END IF;
294: -- Initialize API return status to success
295: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 295: x_return_status := FND_API.G_RET_STS_SUCCESS;

291: IF FND_API.to_Boolean( p_init_msg_list ) THEN
292: FND_MSG_PUB.initialize;
293: END IF;
294: -- Initialize API return status to success
295: x_return_status := FND_API.G_RET_STS_SUCCESS;
296: x_loading_status := 'CN_INSERTED';
297: -- API body
298: IF (p_reason_id = FND_API.G_MISS_NUM) THEN
299: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 298: IF (p_reason_id = FND_API.G_MISS_NUM) THEN

294: -- Initialize API return status to success
295: x_return_status := FND_API.G_RET_STS_SUCCESS;
296: x_loading_status := 'CN_INSERTED';
297: -- API body
298: IF (p_reason_id = FND_API.G_MISS_NUM) THEN
299: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
300: FND_MESSAGE.SET_NAME ('CN' , 'CN_REASON_ID_ERROR');
301: FND_MSG_PUB.Add;
302: END IF;

Line 304: RAISE FND_API.G_EXC_ERROR ;

300: FND_MESSAGE.SET_NAME ('CN' , 'CN_REASON_ID_ERROR');
301: FND_MSG_PUB.Add;
302: END IF;
303: x_loading_status := 'CN_REASON_ID_ERROR';
304: RAISE FND_API.G_EXC_ERROR ;
305: END IF;
306: -- First original record to be moved to CN_REASON_HISTORY table.
307: FOR rec IN reason_cur(p_reason_id)
308: LOOP

Line 348: WHEN FND_API.G_EXC_ERROR THEN

344: cn_reasons_pkg.delete_row(p_reason_id);
345: --
346: END LOOP;
347: EXCEPTION
348: WHEN FND_API.G_EXC_ERROR THEN
349: ROLLBACK TO update_row;
350: x_return_status := FND_API.G_RET_STS_ERROR ;
351: FND_MSG_PUB.Count_And_Get(
352: p_count => x_msg_count ,

Line 350: x_return_status := FND_API.G_RET_STS_ERROR ;

346: END LOOP;
347: EXCEPTION
348: WHEN FND_API.G_EXC_ERROR THEN
349: ROLLBACK TO update_row;
350: x_return_status := FND_API.G_RET_STS_ERROR ;
351: FND_MSG_PUB.Count_And_Get(
352: p_count => x_msg_count ,
353: p_data => x_msg_data ,
354: p_encoded => FND_API.G_FALSE);

Line 354: p_encoded => FND_API.G_FALSE);

350: x_return_status := FND_API.G_RET_STS_ERROR ;
351: FND_MSG_PUB.Count_And_Get(
352: p_count => x_msg_count ,
353: p_data => x_msg_data ,
354: p_encoded => FND_API.G_FALSE);
355: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
356: ROLLBACK TO update_row;
357: x_loading_status := 'UNEXPECTED_ERR';
358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 355: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

351: FND_MSG_PUB.Count_And_Get(
352: p_count => x_msg_count ,
353: p_data => x_msg_data ,
354: p_encoded => FND_API.G_FALSE);
355: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
356: ROLLBACK TO update_row;
357: x_loading_status := 'UNEXPECTED_ERR';
358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
359: FND_MSG_PUB.Count_And_Get(

Line 358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

354: p_encoded => FND_API.G_FALSE);
355: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
356: ROLLBACK TO update_row;
357: x_loading_status := 'UNEXPECTED_ERR';
358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
359: FND_MSG_PUB.Count_And_Get(
360: p_count => x_msg_count ,
361: p_data => x_msg_data ,
362: p_encoded => FND_API.G_FALSE);

Line 362: p_encoded => FND_API.G_FALSE);

358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
359: FND_MSG_PUB.Count_And_Get(
360: p_count => x_msg_count ,
361: p_data => x_msg_data ,
362: p_encoded => FND_API.G_FALSE);
363: WHEN OTHERS THEN
364: ROLLBACK TO update_row;
365: x_loading_status := 'UNEXPECTED_ERR';
366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

362: p_encoded => FND_API.G_FALSE);
363: WHEN OTHERS THEN
364: ROLLBACK TO update_row;
365: x_loading_status := 'UNEXPECTED_ERR';
366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
367: IF FND_MSG_PUB.Check_Msg_Level(
368: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
369: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
370: END IF;

Line 374: p_encoded => FND_API.G_FALSE);

370: END IF;
371: FND_MSG_PUB.Count_And_Get(
372: p_count => x_msg_count ,
373: p_data => x_msg_data ,
374: p_encoded => FND_API.G_FALSE);
375: END;
376: --
377: PROCEDURE delete_worksheet_notes(
378: p_api_version IN NUMBER,

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

375: END;
376: --
377: PROCEDURE delete_worksheet_notes(
378: p_api_version IN NUMBER,
379: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
380: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
381: p_commit IN VARCHAR2 := CN_API.G_FALSE,
382: p_payment_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
383: x_return_status OUT NOCOPY VARCHAR2,

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

376: --
377: PROCEDURE delete_worksheet_notes(
378: p_api_version IN NUMBER,
379: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
380: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
381: p_commit IN VARCHAR2 := CN_API.G_FALSE,
382: p_payment_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
383: x_return_status OUT NOCOPY VARCHAR2,
384: x_msg_count OUT NOCOPY NUMBER,

Line 382: p_payment_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,

378: p_api_version IN NUMBER,
379: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
380: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
381: p_commit IN VARCHAR2 := CN_API.G_FALSE,
382: p_payment_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
383: x_return_status OUT NOCOPY VARCHAR2,
384: x_msg_count OUT NOCOPY NUMBER,
385: x_msg_data OUT NOCOPY VARCHAR2,
386: x_loading_status OUT NOCOPY VARCHAR2) IS

Line 405: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

401: BEGIN
402: -- Standard Start of API savepoint
403: SAVEPOINT delete_worksheet_notes;
404: -- Standard call to check for call compatibility.
405: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
406: p_api_version ,
407: l_api_name,
408: G_PKG_NAME ) THEN
409: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 409: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

405: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
406: p_api_version ,
407: l_api_name,
408: G_PKG_NAME ) THEN
409: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
410: END IF;
411: -- Initialize message list if p_init_msg_list is set to TRUE.
412: IF FND_API.to_Boolean( p_init_msg_list ) THEN
413: FND_MSG_PUB.initialize;

Line 412: IF FND_API.to_Boolean( p_init_msg_list ) THEN

408: G_PKG_NAME ) THEN
409: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
410: END IF;
411: -- Initialize message list if p_init_msg_list is set to TRUE.
412: IF FND_API.to_Boolean( p_init_msg_list ) THEN
413: FND_MSG_PUB.initialize;
414: END IF;
415: -- Initialize API return status to success
416: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 416: x_return_status := FND_API.G_RET_STS_SUCCESS;

412: IF FND_API.to_Boolean( p_init_msg_list ) THEN
413: FND_MSG_PUB.initialize;
414: END IF;
415: -- Initialize API return status to success
416: x_return_status := FND_API.G_RET_STS_SUCCESS;
417: x_loading_status := 'CN_INSERTED';
418: -- API body
419: IF (p_payment_worksheet_id = FND_API.G_MISS_NUM) THEN
420: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 419: IF (p_payment_worksheet_id = FND_API.G_MISS_NUM) THEN

415: -- Initialize API return status to success
416: x_return_status := FND_API.G_RET_STS_SUCCESS;
417: x_loading_status := 'CN_INSERTED';
418: -- API body
419: IF (p_payment_worksheet_id = FND_API.G_MISS_NUM) THEN
420: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
421: FND_MESSAGE.SET_NAME ('CN' , 'CN_WORKSHEET_ID_ERROR');
422: FND_MSG_PUB.Add;
423: END IF;

Line 425: RAISE FND_API.G_EXC_ERROR ;

421: FND_MESSAGE.SET_NAME ('CN' , 'CN_WORKSHEET_ID_ERROR');
422: FND_MSG_PUB.Add;
423: END IF;
424: x_loading_status := 'CN_WORKSHEET_ID_ERROR';
425: RAISE FND_API.G_EXC_ERROR ;
426: END IF;
427: FOR history_rec IN history_cur
428: LOOP
429: cn_reason_history_pkg.delete_row(history_rec.reason_history_id);

Line 438: WHEN FND_API.G_EXC_ERROR THEN

434: cn_reasons_pkg.delete_row(reason_rec.reason_id);
435: END LOOP;
436: --
437: EXCEPTION
438: WHEN FND_API.G_EXC_ERROR THEN
439: ROLLBACK TO delete_worksheet_notes;
440: x_return_status := FND_API.G_RET_STS_ERROR ;
441: FND_MSG_PUB.Count_And_Get(
442: p_count => x_msg_count ,

Line 440: x_return_status := FND_API.G_RET_STS_ERROR ;

436: --
437: EXCEPTION
438: WHEN FND_API.G_EXC_ERROR THEN
439: ROLLBACK TO delete_worksheet_notes;
440: x_return_status := FND_API.G_RET_STS_ERROR ;
441: FND_MSG_PUB.Count_And_Get(
442: p_count => x_msg_count ,
443: p_data => x_msg_data ,
444: p_encoded => FND_API.G_FALSE);

Line 444: p_encoded => FND_API.G_FALSE);

440: x_return_status := FND_API.G_RET_STS_ERROR ;
441: FND_MSG_PUB.Count_And_Get(
442: p_count => x_msg_count ,
443: p_data => x_msg_data ,
444: p_encoded => FND_API.G_FALSE);
445: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
446: ROLLBACK TO delete_worksheet_notes;
447: x_loading_status := 'UNEXPECTED_ERR';
448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 445: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

441: FND_MSG_PUB.Count_And_Get(
442: p_count => x_msg_count ,
443: p_data => x_msg_data ,
444: p_encoded => FND_API.G_FALSE);
445: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
446: ROLLBACK TO delete_worksheet_notes;
447: x_loading_status := 'UNEXPECTED_ERR';
448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
449: FND_MSG_PUB.Count_And_Get(

Line 448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

444: p_encoded => FND_API.G_FALSE);
445: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
446: ROLLBACK TO delete_worksheet_notes;
447: x_loading_status := 'UNEXPECTED_ERR';
448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
449: FND_MSG_PUB.Count_And_Get(
450: p_count => x_msg_count ,
451: p_data => x_msg_data ,
452: p_encoded => FND_API.G_FALSE);

Line 452: p_encoded => FND_API.G_FALSE);

448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
449: FND_MSG_PUB.Count_And_Get(
450: p_count => x_msg_count ,
451: p_data => x_msg_data ,
452: p_encoded => FND_API.G_FALSE);
453: WHEN OTHERS THEN
454: ROLLBACK TO delete_worksheet_notes;
455: x_loading_status := 'UNEXPECTED_ERR';
456: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 456: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

452: p_encoded => FND_API.G_FALSE);
453: WHEN OTHERS THEN
454: ROLLBACK TO delete_worksheet_notes;
455: x_loading_status := 'UNEXPECTED_ERR';
456: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
457: IF FND_MSG_PUB.Check_Msg_Level(
458: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
459: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
460: END IF;

Line 464: p_encoded => FND_API.G_FALSE);

460: END IF;
461: FND_MSG_PUB.Count_And_Get(
462: p_count => x_msg_count ,
463: p_data => x_msg_data ,
464: p_encoded => FND_API.G_FALSE);
465: END;
466: --
467: END;