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

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

6: /* ----------------------------------------------------------------------- */
7:
8: PROCEDURE Create_WS_Line_Items
9: ( p_api_version IN NUMBER,
10: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
11: p_commit IN VARCHAR2 := FND_API.G_FALSE,
12: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
13: p_return_status OUT NOCOPY VARCHAR2,
14: p_msg_count OUT NOCOPY NUMBER,

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

7:
8: PROCEDURE Create_WS_Line_Items
9: ( p_api_version IN NUMBER,
10: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
11: p_commit IN VARCHAR2 := FND_API.G_FALSE,
12: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
13: p_return_status OUT NOCOPY VARCHAR2,
14: p_msg_count OUT NOCOPY NUMBER,
15: p_msg_data OUT NOCOPY VARCHAR2,

Line 12: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,

8: PROCEDURE Create_WS_Line_Items
9: ( p_api_version IN NUMBER,
10: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
11: p_commit IN VARCHAR2 := FND_API.G_FALSE,
12: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
13: p_return_status OUT NOCOPY VARCHAR2,
14: p_msg_count OUT NOCOPY NUMBER,
15: p_msg_data OUT NOCOPY VARCHAR2,
16: p_worksheet_id IN NUMBER

Line 31: if not FND_API.Compatible_API_Call (l_api_version,

27:
28:
29: -- Standard call to check for call compatibility.
30:
31: if not FND_API.Compatible_API_Call (l_api_version,
32: p_api_version,
33: l_api_name,
34: G_PKG_NAME)
35: then

Line 36: raise FND_API.G_EXC_UNEXPECTED_ERROR;

32: p_api_version,
33: l_api_name,
34: G_PKG_NAME)
35: then
36: raise FND_API.G_EXC_UNEXPECTED_ERROR;
37: end if;
38:
39:
40: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 42: if FND_API.to_Boolean (p_init_msg_list) then

38:
39:
40: -- Initialize message list if p_init_msg_list is set to TRUE.
41:
42: if FND_API.to_Boolean (p_init_msg_list) then
43: FND_MSG_PUB.initialize;
44: end if;
45:
46:

Line 57: if FND_API.to_Boolean (p_commit) then

53:
54:
55: -- Standard check of p_commit.
56:
57: if FND_API.to_Boolean (p_commit) then
58: commit work;
59: end if;
60:
61:

Line 69: when FND_API.G_EXC_ERROR then

65: p_data => p_msg_data);
66:
67: EXCEPTION
68:
69: when FND_API.G_EXC_ERROR then
70: rollback to Create_WS_Line_Items_Pvt;
71: p_return_status := FND_API.G_RET_STS_ERROR;
72:
73: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 71: p_return_status := FND_API.G_RET_STS_ERROR;

67: EXCEPTION
68:
69: when FND_API.G_EXC_ERROR then
70: rollback to Create_WS_Line_Items_Pvt;
71: p_return_status := FND_API.G_RET_STS_ERROR;
72:
73: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
74: p_data => p_msg_data);
75:

Line 76: when FND_API.G_EXC_UNEXPECTED_ERROR then

72:
73: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
74: p_data => p_msg_data);
75:
76: when FND_API.G_EXC_UNEXPECTED_ERROR then
77: rollback to Create_WS_Line_Items_Pvt;
78: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
79:
80: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 78: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

74: p_data => p_msg_data);
75:
76: when FND_API.G_EXC_UNEXPECTED_ERROR then
77: rollback to Create_WS_Line_Items_Pvt;
78: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
79:
80: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
81: p_data => p_msg_data);
82:

Line 85: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

81: p_data => p_msg_data);
82:
83: when OTHERS then
84: rollback to Create_WS_Line_Items_Pvt;
85: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
86:
87: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
88: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
89: l_api_name);

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

97: /* ----------------------------------------------------------------------- */
98:
99: PROCEDURE Delete_WS_Line_Items
100: ( p_api_version IN NUMBER,
101: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
102: p_commit IN VARCHAR2 := FND_API.G_FALSE,
103: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
104: p_return_status OUT NOCOPY VARCHAR2,
105: p_msg_count OUT NOCOPY NUMBER,

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

98:
99: PROCEDURE Delete_WS_Line_Items
100: ( p_api_version IN NUMBER,
101: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
102: p_commit IN VARCHAR2 := FND_API.G_FALSE,
103: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
104: p_return_status OUT NOCOPY VARCHAR2,
105: p_msg_count OUT NOCOPY NUMBER,
106: p_msg_data OUT NOCOPY VARCHAR2,

Line 103: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,

99: PROCEDURE Delete_WS_Line_Items
100: ( p_api_version IN NUMBER,
101: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
102: p_commit IN VARCHAR2 := FND_API.G_FALSE,
103: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
104: p_return_status OUT NOCOPY VARCHAR2,
105: p_msg_count OUT NOCOPY NUMBER,
106: p_msg_data OUT NOCOPY VARCHAR2,
107: p_worksheet_id IN NUMBER,

Line 108: p_global_worksheet IN VARCHAR2 := FND_API.G_TRUE

104: p_return_status OUT NOCOPY VARCHAR2,
105: p_msg_count OUT NOCOPY NUMBER,
106: p_msg_data OUT NOCOPY VARCHAR2,
107: p_worksheet_id IN NUMBER,
108: p_global_worksheet IN VARCHAR2 := FND_API.G_TRUE
109: ) IS
110:
111: l_api_name CONSTANT VARCHAR2(30) := 'Delete_WS_Line_Items';
112: l_api_version CONSTANT NUMBER := 1.0;

Line 123: if not FND_API.Compatible_API_Call (l_api_version,

119:
120:
121: -- Standard call to check for call compatibility.
122:
123: if not FND_API.Compatible_API_Call (l_api_version,
124: p_api_version,
125: l_api_name,
126: G_PKG_NAME)
127: then

Line 128: raise FND_API.G_EXC_UNEXPECTED_ERROR;

124: p_api_version,
125: l_api_name,
126: G_PKG_NAME)
127: then
128: raise FND_API.G_EXC_UNEXPECTED_ERROR;
129: end if;
130:
131:
132: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 134: if FND_API.to_Boolean (p_init_msg_list) then

130:
131:
132: -- Initialize message list if p_init_msg_list is set to TRUE.
133:
134: if FND_API.to_Boolean (p_init_msg_list) then
135: FND_MSG_PUB.initialize;
136: end if;
137:
138:

Line 150: if FND_API.to_Boolean (p_commit) then

146:
147:
148: -- Standard check of p_commit.
149:
150: if FND_API.to_Boolean (p_commit) then
151: commit work;
152: end if;
153:
154:

Line 162: when FND_API.G_EXC_ERROR then

158: p_data => p_msg_data);
159:
160: EXCEPTION
161:
162: when FND_API.G_EXC_ERROR then
163: rollback to Delete_WS_Line_Items_Pvt;
164: p_return_status := FND_API.G_RET_STS_ERROR;
165:
166: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 164: p_return_status := FND_API.G_RET_STS_ERROR;

160: EXCEPTION
161:
162: when FND_API.G_EXC_ERROR then
163: rollback to Delete_WS_Line_Items_Pvt;
164: p_return_status := FND_API.G_RET_STS_ERROR;
165:
166: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
167: p_data => p_msg_data);
168:

Line 169: when FND_API.G_EXC_UNEXPECTED_ERROR then

165:
166: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
167: p_data => p_msg_data);
168:
169: when FND_API.G_EXC_UNEXPECTED_ERROR then
170: rollback to Delete_WS_Line_Items_Pvt;
171: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
172:
173: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 171: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

167: p_data => p_msg_data);
168:
169: when FND_API.G_EXC_UNEXPECTED_ERROR then
170: rollback to Delete_WS_Line_Items_Pvt;
171: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
172:
173: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
174: p_data => p_msg_data);
175:

Line 178: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

174: p_data => p_msg_data);
175:
176: when OTHERS then
177: rollback to Delete_WS_Line_Items_Pvt;
178: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
179:
180: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
181: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
182: l_api_name);

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

190: /* ----------------------------------------------------------------------- */
191:
192: PROCEDURE Create_Worksheet
193: ( p_api_version IN NUMBER,
194: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
195: p_commit IN VARCHAR2 := FND_API.G_FALSE,
196: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
197: p_return_status OUT NOCOPY VARCHAR2,
198: p_msg_count OUT NOCOPY NUMBER,

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

191:
192: PROCEDURE Create_Worksheet
193: ( p_api_version IN NUMBER,
194: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
195: p_commit IN VARCHAR2 := FND_API.G_FALSE,
196: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
197: p_return_status OUT NOCOPY VARCHAR2,
198: p_msg_count OUT NOCOPY NUMBER,
199: p_msg_data OUT NOCOPY VARCHAR2,

Line 196: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,

192: PROCEDURE Create_Worksheet
193: ( p_api_version IN NUMBER,
194: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
195: p_commit IN VARCHAR2 := FND_API.G_FALSE,
196: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
197: p_return_status OUT NOCOPY VARCHAR2,
198: p_msg_count OUT NOCOPY NUMBER,
199: p_msg_data OUT NOCOPY VARCHAR2,
200: p_budget_group_id IN NUMBER,

Line 205: p_ws_creation_complete IN VARCHAR2 := FND_API.G_MISS_CHAR,

201: p_budget_calendar_id IN NUMBER,
202: p_worksheet_type IN VARCHAR2 := 'O',
203: p_name IN VARCHAR2,
204: p_description IN VARCHAR2,
205: p_ws_creation_complete IN VARCHAR2 := FND_API.G_MISS_CHAR,
206: p_stage_set_id IN NUMBER,
207: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
208: p_global_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
209: p_global_worksheet_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 207: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,

203: p_name IN VARCHAR2,
204: p_description IN VARCHAR2,
205: p_ws_creation_complete IN VARCHAR2 := FND_API.G_MISS_CHAR,
206: p_stage_set_id IN NUMBER,
207: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
208: p_global_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
209: p_global_worksheet_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
210: p_global_worksheet_option IN VARCHAR2 := FND_API.G_MISS_CHAR,
211: p_local_copy_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 208: p_global_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,

204: p_description IN VARCHAR2,
205: p_ws_creation_complete IN VARCHAR2 := FND_API.G_MISS_CHAR,
206: p_stage_set_id IN NUMBER,
207: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
208: p_global_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
209: p_global_worksheet_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
210: p_global_worksheet_option IN VARCHAR2 := FND_API.G_MISS_CHAR,
211: p_local_copy_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
212: p_copy_of_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,

Line 209: p_global_worksheet_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

205: p_ws_creation_complete IN VARCHAR2 := FND_API.G_MISS_CHAR,
206: p_stage_set_id IN NUMBER,
207: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
208: p_global_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
209: p_global_worksheet_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
210: p_global_worksheet_option IN VARCHAR2 := FND_API.G_MISS_CHAR,
211: p_local_copy_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
212: p_copy_of_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
213: p_freeze_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 210: p_global_worksheet_option IN VARCHAR2 := FND_API.G_MISS_CHAR,

206: p_stage_set_id IN NUMBER,
207: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
208: p_global_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
209: p_global_worksheet_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
210: p_global_worksheet_option IN VARCHAR2 := FND_API.G_MISS_CHAR,
211: p_local_copy_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
212: p_copy_of_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
213: p_freeze_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
214: p_budget_by_position IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 211: p_local_copy_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

207: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
208: p_global_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
209: p_global_worksheet_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
210: p_global_worksheet_option IN VARCHAR2 := FND_API.G_MISS_CHAR,
211: p_local_copy_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
212: p_copy_of_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
213: p_freeze_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
214: p_budget_by_position IN VARCHAR2 := FND_API.G_MISS_CHAR,
215: p_use_revised_element_rates IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 212: p_copy_of_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,

208: p_global_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
209: p_global_worksheet_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
210: p_global_worksheet_option IN VARCHAR2 := FND_API.G_MISS_CHAR,
211: p_local_copy_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
212: p_copy_of_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
213: p_freeze_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
214: p_budget_by_position IN VARCHAR2 := FND_API.G_MISS_CHAR,
215: p_use_revised_element_rates IN VARCHAR2 := FND_API.G_MISS_CHAR,
216: p_num_proposed_years IN NUMBER := FND_API.G_MISS_NUM,

Line 213: p_freeze_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

209: p_global_worksheet_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
210: p_global_worksheet_option IN VARCHAR2 := FND_API.G_MISS_CHAR,
211: p_local_copy_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
212: p_copy_of_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
213: p_freeze_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
214: p_budget_by_position IN VARCHAR2 := FND_API.G_MISS_CHAR,
215: p_use_revised_element_rates IN VARCHAR2 := FND_API.G_MISS_CHAR,
216: p_num_proposed_years IN NUMBER := FND_API.G_MISS_NUM,
217: p_num_years_to_allocate IN NUMBER := FND_API.G_MISS_NUM,

Line 214: p_budget_by_position IN VARCHAR2 := FND_API.G_MISS_CHAR,

210: p_global_worksheet_option IN VARCHAR2 := FND_API.G_MISS_CHAR,
211: p_local_copy_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
212: p_copy_of_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
213: p_freeze_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
214: p_budget_by_position IN VARCHAR2 := FND_API.G_MISS_CHAR,
215: p_use_revised_element_rates IN VARCHAR2 := FND_API.G_MISS_CHAR,
216: p_num_proposed_years IN NUMBER := FND_API.G_MISS_NUM,
217: p_num_years_to_allocate IN NUMBER := FND_API.G_MISS_NUM,
218: p_rounding_factor IN NUMBER := FND_API.G_MISS_NUM,

Line 215: p_use_revised_element_rates IN VARCHAR2 := FND_API.G_MISS_CHAR,

211: p_local_copy_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
212: p_copy_of_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
213: p_freeze_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
214: p_budget_by_position IN VARCHAR2 := FND_API.G_MISS_CHAR,
215: p_use_revised_element_rates IN VARCHAR2 := FND_API.G_MISS_CHAR,
216: p_num_proposed_years IN NUMBER := FND_API.G_MISS_NUM,
217: p_num_years_to_allocate IN NUMBER := FND_API.G_MISS_NUM,
218: p_rounding_factor IN NUMBER := FND_API.G_MISS_NUM,
219: p_gl_cutoff_period IN DATE := FND_API.G_MISS_DATE,

Line 216: p_num_proposed_years IN NUMBER := FND_API.G_MISS_NUM,

212: p_copy_of_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
213: p_freeze_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
214: p_budget_by_position IN VARCHAR2 := FND_API.G_MISS_CHAR,
215: p_use_revised_element_rates IN VARCHAR2 := FND_API.G_MISS_CHAR,
216: p_num_proposed_years IN NUMBER := FND_API.G_MISS_NUM,
217: p_num_years_to_allocate IN NUMBER := FND_API.G_MISS_NUM,
218: p_rounding_factor IN NUMBER := FND_API.G_MISS_NUM,
219: p_gl_cutoff_period IN DATE := FND_API.G_MISS_DATE,
220: p_budget_version_id IN NUMBER := FND_API.G_MISS_NUM,

Line 217: p_num_years_to_allocate IN NUMBER := FND_API.G_MISS_NUM,

213: p_freeze_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
214: p_budget_by_position IN VARCHAR2 := FND_API.G_MISS_CHAR,
215: p_use_revised_element_rates IN VARCHAR2 := FND_API.G_MISS_CHAR,
216: p_num_proposed_years IN NUMBER := FND_API.G_MISS_NUM,
217: p_num_years_to_allocate IN NUMBER := FND_API.G_MISS_NUM,
218: p_rounding_factor IN NUMBER := FND_API.G_MISS_NUM,
219: p_gl_cutoff_period IN DATE := FND_API.G_MISS_DATE,
220: p_budget_version_id IN NUMBER := FND_API.G_MISS_NUM,
221: p_gl_budget_set_id IN NUMBER := FND_API.G_MISS_NUM,

Line 218: p_rounding_factor IN NUMBER := FND_API.G_MISS_NUM,

214: p_budget_by_position IN VARCHAR2 := FND_API.G_MISS_CHAR,
215: p_use_revised_element_rates IN VARCHAR2 := FND_API.G_MISS_CHAR,
216: p_num_proposed_years IN NUMBER := FND_API.G_MISS_NUM,
217: p_num_years_to_allocate IN NUMBER := FND_API.G_MISS_NUM,
218: p_rounding_factor IN NUMBER := FND_API.G_MISS_NUM,
219: p_gl_cutoff_period IN DATE := FND_API.G_MISS_DATE,
220: p_budget_version_id IN NUMBER := FND_API.G_MISS_NUM,
221: p_gl_budget_set_id IN NUMBER := FND_API.G_MISS_NUM,
222: p_include_stat_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 219: p_gl_cutoff_period IN DATE := FND_API.G_MISS_DATE,

215: p_use_revised_element_rates IN VARCHAR2 := FND_API.G_MISS_CHAR,
216: p_num_proposed_years IN NUMBER := FND_API.G_MISS_NUM,
217: p_num_years_to_allocate IN NUMBER := FND_API.G_MISS_NUM,
218: p_rounding_factor IN NUMBER := FND_API.G_MISS_NUM,
219: p_gl_cutoff_period IN DATE := FND_API.G_MISS_DATE,
220: p_budget_version_id IN NUMBER := FND_API.G_MISS_NUM,
221: p_gl_budget_set_id IN NUMBER := FND_API.G_MISS_NUM,
222: p_include_stat_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
223: p_include_trans_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 220: p_budget_version_id IN NUMBER := FND_API.G_MISS_NUM,

216: p_num_proposed_years IN NUMBER := FND_API.G_MISS_NUM,
217: p_num_years_to_allocate IN NUMBER := FND_API.G_MISS_NUM,
218: p_rounding_factor IN NUMBER := FND_API.G_MISS_NUM,
219: p_gl_cutoff_period IN DATE := FND_API.G_MISS_DATE,
220: p_budget_version_id IN NUMBER := FND_API.G_MISS_NUM,
221: p_gl_budget_set_id IN NUMBER := FND_API.G_MISS_NUM,
222: p_include_stat_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
223: p_include_trans_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
224: p_include_adj_period IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 221: p_gl_budget_set_id IN NUMBER := FND_API.G_MISS_NUM,

217: p_num_years_to_allocate IN NUMBER := FND_API.G_MISS_NUM,
218: p_rounding_factor IN NUMBER := FND_API.G_MISS_NUM,
219: p_gl_cutoff_period IN DATE := FND_API.G_MISS_DATE,
220: p_budget_version_id IN NUMBER := FND_API.G_MISS_NUM,
221: p_gl_budget_set_id IN NUMBER := FND_API.G_MISS_NUM,
222: p_include_stat_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
223: p_include_trans_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
224: p_include_adj_period IN VARCHAR2 := FND_API.G_MISS_CHAR,
225: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,

Line 222: p_include_stat_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,

218: p_rounding_factor IN NUMBER := FND_API.G_MISS_NUM,
219: p_gl_cutoff_period IN DATE := FND_API.G_MISS_DATE,
220: p_budget_version_id IN NUMBER := FND_API.G_MISS_NUM,
221: p_gl_budget_set_id IN NUMBER := FND_API.G_MISS_NUM,
222: p_include_stat_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
223: p_include_trans_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
224: p_include_adj_period IN VARCHAR2 := FND_API.G_MISS_CHAR,
225: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
226: p_parameter_set_id IN NUMBER := FND_API.G_MISS_NUM,

Line 223: p_include_trans_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,

219: p_gl_cutoff_period IN DATE := FND_API.G_MISS_DATE,
220: p_budget_version_id IN NUMBER := FND_API.G_MISS_NUM,
221: p_gl_budget_set_id IN NUMBER := FND_API.G_MISS_NUM,
222: p_include_stat_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
223: p_include_trans_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
224: p_include_adj_period IN VARCHAR2 := FND_API.G_MISS_CHAR,
225: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
226: p_parameter_set_id IN NUMBER := FND_API.G_MISS_NUM,
227: p_constraint_set_id IN NUMBER := FND_API.G_MISS_NUM,

Line 224: p_include_adj_period IN VARCHAR2 := FND_API.G_MISS_CHAR,

220: p_budget_version_id IN NUMBER := FND_API.G_MISS_NUM,
221: p_gl_budget_set_id IN NUMBER := FND_API.G_MISS_NUM,
222: p_include_stat_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
223: p_include_trans_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
224: p_include_adj_period IN VARCHAR2 := FND_API.G_MISS_CHAR,
225: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
226: p_parameter_set_id IN NUMBER := FND_API.G_MISS_NUM,
227: p_constraint_set_id IN NUMBER := FND_API.G_MISS_NUM,
228: p_allocrule_set_id IN NUMBER := FND_API.G_MISS_NUM,

Line 225: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,

221: p_gl_budget_set_id IN NUMBER := FND_API.G_MISS_NUM,
222: p_include_stat_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
223: p_include_trans_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
224: p_include_adj_period IN VARCHAR2 := FND_API.G_MISS_CHAR,
225: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
226: p_parameter_set_id IN NUMBER := FND_API.G_MISS_NUM,
227: p_constraint_set_id IN NUMBER := FND_API.G_MISS_NUM,
228: p_allocrule_set_id IN NUMBER := FND_API.G_MISS_NUM,
229: p_date_submitted IN DATE := FND_API.G_MISS_DATE,

Line 226: p_parameter_set_id IN NUMBER := FND_API.G_MISS_NUM,

222: p_include_stat_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
223: p_include_trans_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
224: p_include_adj_period IN VARCHAR2 := FND_API.G_MISS_CHAR,
225: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
226: p_parameter_set_id IN NUMBER := FND_API.G_MISS_NUM,
227: p_constraint_set_id IN NUMBER := FND_API.G_MISS_NUM,
228: p_allocrule_set_id IN NUMBER := FND_API.G_MISS_NUM,
229: p_date_submitted IN DATE := FND_API.G_MISS_DATE,
230: p_submitted_by IN NUMBER := FND_API.G_MISS_NUM,

Line 227: p_constraint_set_id IN NUMBER := FND_API.G_MISS_NUM,

223: p_include_trans_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
224: p_include_adj_period IN VARCHAR2 := FND_API.G_MISS_CHAR,
225: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
226: p_parameter_set_id IN NUMBER := FND_API.G_MISS_NUM,
227: p_constraint_set_id IN NUMBER := FND_API.G_MISS_NUM,
228: p_allocrule_set_id IN NUMBER := FND_API.G_MISS_NUM,
229: p_date_submitted IN DATE := FND_API.G_MISS_DATE,
230: p_submitted_by IN NUMBER := FND_API.G_MISS_NUM,
231: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 228: p_allocrule_set_id IN NUMBER := FND_API.G_MISS_NUM,

224: p_include_adj_period IN VARCHAR2 := FND_API.G_MISS_CHAR,
225: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
226: p_parameter_set_id IN NUMBER := FND_API.G_MISS_NUM,
227: p_constraint_set_id IN NUMBER := FND_API.G_MISS_NUM,
228: p_allocrule_set_id IN NUMBER := FND_API.G_MISS_NUM,
229: p_date_submitted IN DATE := FND_API.G_MISS_DATE,
230: p_submitted_by IN NUMBER := FND_API.G_MISS_NUM,
231: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
232: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 229: p_date_submitted IN DATE := FND_API.G_MISS_DATE,

225: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
226: p_parameter_set_id IN NUMBER := FND_API.G_MISS_NUM,
227: p_constraint_set_id IN NUMBER := FND_API.G_MISS_NUM,
228: p_allocrule_set_id IN NUMBER := FND_API.G_MISS_NUM,
229: p_date_submitted IN DATE := FND_API.G_MISS_DATE,
230: p_submitted_by IN NUMBER := FND_API.G_MISS_NUM,
231: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
232: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
233: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 230: p_submitted_by IN NUMBER := FND_API.G_MISS_NUM,

226: p_parameter_set_id IN NUMBER := FND_API.G_MISS_NUM,
227: p_constraint_set_id IN NUMBER := FND_API.G_MISS_NUM,
228: p_allocrule_set_id IN NUMBER := FND_API.G_MISS_NUM,
229: p_date_submitted IN DATE := FND_API.G_MISS_DATE,
230: p_submitted_by IN NUMBER := FND_API.G_MISS_NUM,
231: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
232: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
233: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
234: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 231: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

227: p_constraint_set_id IN NUMBER := FND_API.G_MISS_NUM,
228: p_allocrule_set_id IN NUMBER := FND_API.G_MISS_NUM,
229: p_date_submitted IN DATE := FND_API.G_MISS_DATE,
230: p_submitted_by IN NUMBER := FND_API.G_MISS_NUM,
231: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
232: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
233: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
234: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
235: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 232: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

228: p_allocrule_set_id IN NUMBER := FND_API.G_MISS_NUM,
229: p_date_submitted IN DATE := FND_API.G_MISS_DATE,
230: p_submitted_by IN NUMBER := FND_API.G_MISS_NUM,
231: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
232: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
233: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
234: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
235: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
236: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 233: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

229: p_date_submitted IN DATE := FND_API.G_MISS_DATE,
230: p_submitted_by IN NUMBER := FND_API.G_MISS_NUM,
231: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
232: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
233: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
234: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
235: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
236: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
237: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 234: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

230: p_submitted_by IN NUMBER := FND_API.G_MISS_NUM,
231: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
232: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
233: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
234: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
235: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
236: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
237: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
238: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 235: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

231: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
232: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
233: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
234: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
235: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
236: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
237: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
238: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
239: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 236: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

232: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
233: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
234: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
235: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
236: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
237: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
238: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
239: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
240: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 237: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

233: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
234: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
235: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
236: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
237: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
238: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
239: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
240: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
241: p_context IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 238: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

234: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
235: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
236: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
237: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
238: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
239: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
240: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
241: p_context IN VARCHAR2 := FND_API.G_MISS_CHAR,
242: p_create_non_pos_line_items IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 239: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

235: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
236: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
237: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
238: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
239: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
240: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
241: p_context IN VARCHAR2 := FND_API.G_MISS_CHAR,
242: p_create_non_pos_line_items IN VARCHAR2 := FND_API.G_MISS_CHAR,
243: p_apply_element_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 240: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

236: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
237: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
238: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
239: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
240: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
241: p_context IN VARCHAR2 := FND_API.G_MISS_CHAR,
242: p_create_non_pos_line_items IN VARCHAR2 := FND_API.G_MISS_CHAR,
243: p_apply_element_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
244: p_apply_position_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 241: p_context IN VARCHAR2 := FND_API.G_MISS_CHAR,

237: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
238: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
239: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
240: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
241: p_context IN VARCHAR2 := FND_API.G_MISS_CHAR,
242: p_create_non_pos_line_items IN VARCHAR2 := FND_API.G_MISS_CHAR,
243: p_apply_element_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
244: p_apply_position_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
245: p_create_positions IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 242: p_create_non_pos_line_items IN VARCHAR2 := FND_API.G_MISS_CHAR,

238: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
239: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
240: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
241: p_context IN VARCHAR2 := FND_API.G_MISS_CHAR,
242: p_create_non_pos_line_items IN VARCHAR2 := FND_API.G_MISS_CHAR,
243: p_apply_element_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
244: p_apply_position_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
245: p_create_positions IN VARCHAR2 := FND_API.G_MISS_CHAR,
246: p_create_summary_totals IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 243: p_apply_element_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,

239: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
240: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
241: p_context IN VARCHAR2 := FND_API.G_MISS_CHAR,
242: p_create_non_pos_line_items IN VARCHAR2 := FND_API.G_MISS_CHAR,
243: p_apply_element_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
244: p_apply_position_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
245: p_create_positions IN VARCHAR2 := FND_API.G_MISS_CHAR,
246: p_create_summary_totals IN VARCHAR2 := FND_API.G_MISS_CHAR,
247: p_apply_constraints IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 244: p_apply_position_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,

240: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
241: p_context IN VARCHAR2 := FND_API.G_MISS_CHAR,
242: p_create_non_pos_line_items IN VARCHAR2 := FND_API.G_MISS_CHAR,
243: p_apply_element_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
244: p_apply_position_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
245: p_create_positions IN VARCHAR2 := FND_API.G_MISS_CHAR,
246: p_create_summary_totals IN VARCHAR2 := FND_API.G_MISS_CHAR,
247: p_apply_constraints IN VARCHAR2 := FND_API.G_MISS_CHAR,
248: p_flex_mapping_set_id IN NUMBER := FND_API.G_MISS_NUM,

Line 245: p_create_positions IN VARCHAR2 := FND_API.G_MISS_CHAR,

241: p_context IN VARCHAR2 := FND_API.G_MISS_CHAR,
242: p_create_non_pos_line_items IN VARCHAR2 := FND_API.G_MISS_CHAR,
243: p_apply_element_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
244: p_apply_position_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
245: p_create_positions IN VARCHAR2 := FND_API.G_MISS_CHAR,
246: p_create_summary_totals IN VARCHAR2 := FND_API.G_MISS_CHAR,
247: p_apply_constraints IN VARCHAR2 := FND_API.G_MISS_CHAR,
248: p_flex_mapping_set_id IN NUMBER := FND_API.G_MISS_NUM,
249: p_include_gl_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 246: p_create_summary_totals IN VARCHAR2 := FND_API.G_MISS_CHAR,

242: p_create_non_pos_line_items IN VARCHAR2 := FND_API.G_MISS_CHAR,
243: p_apply_element_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
244: p_apply_position_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
245: p_create_positions IN VARCHAR2 := FND_API.G_MISS_CHAR,
246: p_create_summary_totals IN VARCHAR2 := FND_API.G_MISS_CHAR,
247: p_apply_constraints IN VARCHAR2 := FND_API.G_MISS_CHAR,
248: p_flex_mapping_set_id IN NUMBER := FND_API.G_MISS_NUM,
249: p_include_gl_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
250: p_include_gl_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 247: p_apply_constraints IN VARCHAR2 := FND_API.G_MISS_CHAR,

243: p_apply_element_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
244: p_apply_position_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
245: p_create_positions IN VARCHAR2 := FND_API.G_MISS_CHAR,
246: p_create_summary_totals IN VARCHAR2 := FND_API.G_MISS_CHAR,
247: p_apply_constraints IN VARCHAR2 := FND_API.G_MISS_CHAR,
248: p_flex_mapping_set_id IN NUMBER := FND_API.G_MISS_NUM,
249: p_include_gl_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
250: p_include_gl_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
251: p_include_gl_other_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 248: p_flex_mapping_set_id IN NUMBER := FND_API.G_MISS_NUM,

244: p_apply_position_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
245: p_create_positions IN VARCHAR2 := FND_API.G_MISS_CHAR,
246: p_create_summary_totals IN VARCHAR2 := FND_API.G_MISS_CHAR,
247: p_apply_constraints IN VARCHAR2 := FND_API.G_MISS_CHAR,
248: p_flex_mapping_set_id IN NUMBER := FND_API.G_MISS_NUM,
249: p_include_gl_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
250: p_include_gl_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
251: p_include_gl_other_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
252: p_include_cbc_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 249: p_include_gl_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,

245: p_create_positions IN VARCHAR2 := FND_API.G_MISS_CHAR,
246: p_create_summary_totals IN VARCHAR2 := FND_API.G_MISS_CHAR,
247: p_apply_constraints IN VARCHAR2 := FND_API.G_MISS_CHAR,
248: p_flex_mapping_set_id IN NUMBER := FND_API.G_MISS_NUM,
249: p_include_gl_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
250: p_include_gl_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
251: p_include_gl_other_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
252: p_include_cbc_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
253: p_include_cbc_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 250: p_include_gl_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,

246: p_create_summary_totals IN VARCHAR2 := FND_API.G_MISS_CHAR,
247: p_apply_constraints IN VARCHAR2 := FND_API.G_MISS_CHAR,
248: p_flex_mapping_set_id IN NUMBER := FND_API.G_MISS_NUM,
249: p_include_gl_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
250: p_include_gl_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
251: p_include_gl_other_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
252: p_include_cbc_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
253: p_include_cbc_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
254: p_include_cbc_budget_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 251: p_include_gl_other_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,

247: p_apply_constraints IN VARCHAR2 := FND_API.G_MISS_CHAR,
248: p_flex_mapping_set_id IN NUMBER := FND_API.G_MISS_NUM,
249: p_include_gl_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
250: p_include_gl_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
251: p_include_gl_other_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
252: p_include_cbc_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
253: p_include_cbc_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
254: p_include_cbc_budget_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
255: p_federal_ws_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 252: p_include_cbc_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,

248: p_flex_mapping_set_id IN NUMBER := FND_API.G_MISS_NUM,
249: p_include_gl_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
250: p_include_gl_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
251: p_include_gl_other_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
252: p_include_cbc_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
253: p_include_cbc_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
254: p_include_cbc_budget_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
255: p_federal_ws_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
256: /* bug no 4725091 */

Line 253: p_include_cbc_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,

249: p_include_gl_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
250: p_include_gl_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
251: p_include_gl_other_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
252: p_include_cbc_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
253: p_include_cbc_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
254: p_include_cbc_budget_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
255: p_federal_ws_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
256: /* bug no 4725091 */
257: p_include_gl_forwd_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 254: p_include_cbc_budget_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,

250: p_include_gl_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
251: p_include_gl_other_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
252: p_include_cbc_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
253: p_include_cbc_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
254: p_include_cbc_budget_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
255: p_federal_ws_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
256: /* bug no 4725091 */
257: p_include_gl_forwd_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
258: p_worksheet_id OUT NOCOPY NUMBER

Line 255: p_federal_ws_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

251: p_include_gl_other_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
252: p_include_cbc_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
253: p_include_cbc_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
254: p_include_cbc_budget_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
255: p_federal_ws_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
256: /* bug no 4725091 */
257: p_include_gl_forwd_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
258: p_worksheet_id OUT NOCOPY NUMBER
259: ) IS

Line 257: p_include_gl_forwd_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,

253: p_include_cbc_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
254: p_include_cbc_budget_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
255: p_federal_ws_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
256: /* bug no 4725091 */
257: p_include_gl_forwd_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
258: p_worksheet_id OUT NOCOPY NUMBER
259: ) IS
260:
261: l_api_name CONSTANT VARCHAR2(30) := 'Create_Worksheet';

Line 273: if not FND_API.Compatible_API_Call (l_api_version,

269:
270:
271: -- Standard call to check for call compatibility.
272:
273: if not FND_API.Compatible_API_Call (l_api_version,
274: p_api_version,
275: l_api_name,
276: G_PKG_NAME)
277: then

Line 278: raise FND_API.G_EXC_UNEXPECTED_ERROR;

274: p_api_version,
275: l_api_name,
276: G_PKG_NAME)
277: then
278: raise FND_API.G_EXC_UNEXPECTED_ERROR;
279: end if;
280:
281:
282: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 284: if FND_API.to_Boolean (p_init_msg_list) then

280:
281:
282: -- Initialize message list if p_init_msg_list is set to TRUE.
283:
284: if FND_API.to_Boolean (p_init_msg_list) then
285: FND_MSG_PUB.initialize;
286: end if;
287:
288:

Line 358: if FND_API.to_Boolean (p_commit) then

354: p_include_gl_forwd_balance => p_include_gl_forwd_balance);
355:
356: -- Standard check of p_commit.
357:
358: if FND_API.to_Boolean (p_commit) then
359: commit work;
360: end if;
361:
362:

Line 370: when FND_API.G_EXC_ERROR then

366: p_data => p_msg_data);
367:
368: EXCEPTION
369:
370: when FND_API.G_EXC_ERROR then
371: rollback to Create_Worksheet_Pvt;
372: p_return_status := FND_API.G_RET_STS_ERROR;
373:
374: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 372: p_return_status := FND_API.G_RET_STS_ERROR;

368: EXCEPTION
369:
370: when FND_API.G_EXC_ERROR then
371: rollback to Create_Worksheet_Pvt;
372: p_return_status := FND_API.G_RET_STS_ERROR;
373:
374: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
375: p_data => p_msg_data);
376:

Line 377: when FND_API.G_EXC_UNEXPECTED_ERROR then

373:
374: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
375: p_data => p_msg_data);
376:
377: when FND_API.G_EXC_UNEXPECTED_ERROR then
378: rollback to Create_Worksheet_Pvt;
379: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
380:
381: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 379: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

375: p_data => p_msg_data);
376:
377: when FND_API.G_EXC_UNEXPECTED_ERROR then
378: rollback to Create_Worksheet_Pvt;
379: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
380:
381: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
382: p_data => p_msg_data);
383:

Line 386: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

382: p_data => p_msg_data);
383:
384: when OTHERS then
385: rollback to Create_Worksheet_Pvt;
386: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
387:
388: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
389: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
390: l_api_name);

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

398: /* ----------------------------------------------------------------------- */
399:
400: PROCEDURE Update_Worksheet
401: ( p_api_version IN NUMBER,
402: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
403: p_commit IN VARCHAR2 := FND_API.G_FALSE,
404: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
405: p_return_status OUT NOCOPY VARCHAR2,
406: p_msg_count OUT NOCOPY NUMBER,

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

399:
400: PROCEDURE Update_Worksheet
401: ( p_api_version IN NUMBER,
402: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
403: p_commit IN VARCHAR2 := FND_API.G_FALSE,
404: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
405: p_return_status OUT NOCOPY VARCHAR2,
406: p_msg_count OUT NOCOPY NUMBER,
407: p_msg_data OUT NOCOPY VARCHAR2,

Line 404: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,

400: PROCEDURE Update_Worksheet
401: ( p_api_version IN NUMBER,
402: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
403: p_commit IN VARCHAR2 := FND_API.G_FALSE,
404: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
405: p_return_status OUT NOCOPY VARCHAR2,
406: p_msg_count OUT NOCOPY NUMBER,
407: p_msg_data OUT NOCOPY VARCHAR2,
408: p_worksheet_id IN NUMBER,

Line 409: p_worksheet_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

405: p_return_status OUT NOCOPY VARCHAR2,
406: p_msg_count OUT NOCOPY NUMBER,
407: p_msg_data OUT NOCOPY VARCHAR2,
408: p_worksheet_id IN NUMBER,
409: p_worksheet_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
410: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
411: p_ws_creation_complete IN VARCHAR2 := FND_API.G_MISS_CHAR,
412: p_global_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
413: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,

Line 410: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

406: p_msg_count OUT NOCOPY NUMBER,
407: p_msg_data OUT NOCOPY VARCHAR2,
408: p_worksheet_id IN NUMBER,
409: p_worksheet_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
410: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
411: p_ws_creation_complete IN VARCHAR2 := FND_API.G_MISS_CHAR,
412: p_global_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
413: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
414: p_local_copy_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 411: p_ws_creation_complete IN VARCHAR2 := FND_API.G_MISS_CHAR,

407: p_msg_data OUT NOCOPY VARCHAR2,
408: p_worksheet_id IN NUMBER,
409: p_worksheet_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
410: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
411: p_ws_creation_complete IN VARCHAR2 := FND_API.G_MISS_CHAR,
412: p_global_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
413: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
414: p_local_copy_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
415: p_copy_of_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,

Line 412: p_global_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,

408: p_worksheet_id IN NUMBER,
409: p_worksheet_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
410: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
411: p_ws_creation_complete IN VARCHAR2 := FND_API.G_MISS_CHAR,
412: p_global_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
413: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
414: p_local_copy_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
415: p_copy_of_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
416: p_freeze_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 413: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,

409: p_worksheet_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
410: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
411: p_ws_creation_complete IN VARCHAR2 := FND_API.G_MISS_CHAR,
412: p_global_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
413: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
414: p_local_copy_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
415: p_copy_of_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
416: p_freeze_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
417: p_use_revised_element_rates IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 414: p_local_copy_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

410: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
411: p_ws_creation_complete IN VARCHAR2 := FND_API.G_MISS_CHAR,
412: p_global_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
413: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
414: p_local_copy_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
415: p_copy_of_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
416: p_freeze_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
417: p_use_revised_element_rates IN VARCHAR2 := FND_API.G_MISS_CHAR,
418: /* Bug # 3083970 */

Line 415: p_copy_of_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,

411: p_ws_creation_complete IN VARCHAR2 := FND_API.G_MISS_CHAR,
412: p_global_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
413: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
414: p_local_copy_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
415: p_copy_of_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
416: p_freeze_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
417: p_use_revised_element_rates IN VARCHAR2 := FND_API.G_MISS_CHAR,
418: /* Bug # 3083970 */
419: p_num_proposed_years IN NUMBER := FND_API.G_MISS_NUM,

Line 416: p_freeze_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

412: p_global_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
413: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
414: p_local_copy_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
415: p_copy_of_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
416: p_freeze_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
417: p_use_revised_element_rates IN VARCHAR2 := FND_API.G_MISS_CHAR,
418: /* Bug # 3083970 */
419: p_num_proposed_years IN NUMBER := FND_API.G_MISS_NUM,
420: p_rounding_factor IN NUMBER := FND_API.G_MISS_NUM,

Line 417: p_use_revised_element_rates IN VARCHAR2 := FND_API.G_MISS_CHAR,

413: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
414: p_local_copy_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
415: p_copy_of_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
416: p_freeze_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
417: p_use_revised_element_rates IN VARCHAR2 := FND_API.G_MISS_CHAR,
418: /* Bug # 3083970 */
419: p_num_proposed_years IN NUMBER := FND_API.G_MISS_NUM,
420: p_rounding_factor IN NUMBER := FND_API.G_MISS_NUM,
421: /* End bug */

Line 419: p_num_proposed_years IN NUMBER := FND_API.G_MISS_NUM,

415: p_copy_of_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
416: p_freeze_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
417: p_use_revised_element_rates IN VARCHAR2 := FND_API.G_MISS_CHAR,
418: /* Bug # 3083970 */
419: p_num_proposed_years IN NUMBER := FND_API.G_MISS_NUM,
420: p_rounding_factor IN NUMBER := FND_API.G_MISS_NUM,
421: /* End bug */
422: p_date_submitted IN DATE := FND_API.G_MISS_DATE,
423: p_submitted_by IN NUMBER := FND_API.G_MISS_NUM,

Line 420: p_rounding_factor IN NUMBER := FND_API.G_MISS_NUM,

416: p_freeze_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
417: p_use_revised_element_rates IN VARCHAR2 := FND_API.G_MISS_CHAR,
418: /* Bug # 3083970 */
419: p_num_proposed_years IN NUMBER := FND_API.G_MISS_NUM,
420: p_rounding_factor IN NUMBER := FND_API.G_MISS_NUM,
421: /* End bug */
422: p_date_submitted IN DATE := FND_API.G_MISS_DATE,
423: p_submitted_by IN NUMBER := FND_API.G_MISS_NUM,
424: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 422: p_date_submitted IN DATE := FND_API.G_MISS_DATE,

418: /* Bug # 3083970 */
419: p_num_proposed_years IN NUMBER := FND_API.G_MISS_NUM,
420: p_rounding_factor IN NUMBER := FND_API.G_MISS_NUM,
421: /* End bug */
422: p_date_submitted IN DATE := FND_API.G_MISS_DATE,
423: p_submitted_by IN NUMBER := FND_API.G_MISS_NUM,
424: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
425: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
426: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 423: p_submitted_by IN NUMBER := FND_API.G_MISS_NUM,

419: p_num_proposed_years IN NUMBER := FND_API.G_MISS_NUM,
420: p_rounding_factor IN NUMBER := FND_API.G_MISS_NUM,
421: /* End bug */
422: p_date_submitted IN DATE := FND_API.G_MISS_DATE,
423: p_submitted_by IN NUMBER := FND_API.G_MISS_NUM,
424: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
425: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
426: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
427: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 424: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

420: p_rounding_factor IN NUMBER := FND_API.G_MISS_NUM,
421: /* End bug */
422: p_date_submitted IN DATE := FND_API.G_MISS_DATE,
423: p_submitted_by IN NUMBER := FND_API.G_MISS_NUM,
424: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
425: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
426: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
427: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
428: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 425: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

421: /* End bug */
422: p_date_submitted IN DATE := FND_API.G_MISS_DATE,
423: p_submitted_by IN NUMBER := FND_API.G_MISS_NUM,
424: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
425: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
426: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
427: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
428: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
429: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 426: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

422: p_date_submitted IN DATE := FND_API.G_MISS_DATE,
423: p_submitted_by IN NUMBER := FND_API.G_MISS_NUM,
424: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
425: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
426: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
427: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
428: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
429: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
430: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 427: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

423: p_submitted_by IN NUMBER := FND_API.G_MISS_NUM,
424: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
425: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
426: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
427: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
428: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
429: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
430: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
431: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 428: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

424: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
425: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
426: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
427: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
428: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
429: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
430: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
431: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
432: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 429: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

425: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
426: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
427: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
428: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
429: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
430: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
431: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
432: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
433: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 430: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

426: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
427: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
428: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
429: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
430: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
431: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
432: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
433: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
434: p_context IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 431: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

427: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
428: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
429: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
430: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
431: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
432: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
433: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
434: p_context IN VARCHAR2 := FND_API.G_MISS_CHAR,
435: p_create_non_pos_line_items IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 432: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

428: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
429: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
430: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
431: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
432: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
433: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
434: p_context IN VARCHAR2 := FND_API.G_MISS_CHAR,
435: p_create_non_pos_line_items IN VARCHAR2 := FND_API.G_MISS_CHAR,
436: p_apply_element_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 433: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

429: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
430: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
431: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
432: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
433: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
434: p_context IN VARCHAR2 := FND_API.G_MISS_CHAR,
435: p_create_non_pos_line_items IN VARCHAR2 := FND_API.G_MISS_CHAR,
436: p_apply_element_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
437: p_apply_position_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 434: p_context IN VARCHAR2 := FND_API.G_MISS_CHAR,

430: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
431: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
432: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
433: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
434: p_context IN VARCHAR2 := FND_API.G_MISS_CHAR,
435: p_create_non_pos_line_items IN VARCHAR2 := FND_API.G_MISS_CHAR,
436: p_apply_element_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
437: p_apply_position_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
438: p_create_positions IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 435: p_create_non_pos_line_items IN VARCHAR2 := FND_API.G_MISS_CHAR,

431: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
432: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
433: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
434: p_context IN VARCHAR2 := FND_API.G_MISS_CHAR,
435: p_create_non_pos_line_items IN VARCHAR2 := FND_API.G_MISS_CHAR,
436: p_apply_element_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
437: p_apply_position_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
438: p_create_positions IN VARCHAR2 := FND_API.G_MISS_CHAR,
439: p_create_summary_totals IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 436: p_apply_element_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,

432: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
433: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
434: p_context IN VARCHAR2 := FND_API.G_MISS_CHAR,
435: p_create_non_pos_line_items IN VARCHAR2 := FND_API.G_MISS_CHAR,
436: p_apply_element_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
437: p_apply_position_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
438: p_create_positions IN VARCHAR2 := FND_API.G_MISS_CHAR,
439: p_create_summary_totals IN VARCHAR2 := FND_API.G_MISS_CHAR,
440: p_apply_constraints IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 437: p_apply_position_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,

433: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
434: p_context IN VARCHAR2 := FND_API.G_MISS_CHAR,
435: p_create_non_pos_line_items IN VARCHAR2 := FND_API.G_MISS_CHAR,
436: p_apply_element_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
437: p_apply_position_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
438: p_create_positions IN VARCHAR2 := FND_API.G_MISS_CHAR,
439: p_create_summary_totals IN VARCHAR2 := FND_API.G_MISS_CHAR,
440: p_apply_constraints IN VARCHAR2 := FND_API.G_MISS_CHAR,
441: p_include_gl_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 438: p_create_positions IN VARCHAR2 := FND_API.G_MISS_CHAR,

434: p_context IN VARCHAR2 := FND_API.G_MISS_CHAR,
435: p_create_non_pos_line_items IN VARCHAR2 := FND_API.G_MISS_CHAR,
436: p_apply_element_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
437: p_apply_position_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
438: p_create_positions IN VARCHAR2 := FND_API.G_MISS_CHAR,
439: p_create_summary_totals IN VARCHAR2 := FND_API.G_MISS_CHAR,
440: p_apply_constraints IN VARCHAR2 := FND_API.G_MISS_CHAR,
441: p_include_gl_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
442: p_include_gl_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 439: p_create_summary_totals IN VARCHAR2 := FND_API.G_MISS_CHAR,

435: p_create_non_pos_line_items IN VARCHAR2 := FND_API.G_MISS_CHAR,
436: p_apply_element_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
437: p_apply_position_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
438: p_create_positions IN VARCHAR2 := FND_API.G_MISS_CHAR,
439: p_create_summary_totals IN VARCHAR2 := FND_API.G_MISS_CHAR,
440: p_apply_constraints IN VARCHAR2 := FND_API.G_MISS_CHAR,
441: p_include_gl_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
442: p_include_gl_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
443: p_include_gl_other_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 440: p_apply_constraints IN VARCHAR2 := FND_API.G_MISS_CHAR,

436: p_apply_element_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
437: p_apply_position_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
438: p_create_positions IN VARCHAR2 := FND_API.G_MISS_CHAR,
439: p_create_summary_totals IN VARCHAR2 := FND_API.G_MISS_CHAR,
440: p_apply_constraints IN VARCHAR2 := FND_API.G_MISS_CHAR,
441: p_include_gl_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
442: p_include_gl_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
443: p_include_gl_other_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
444: p_include_cbc_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 441: p_include_gl_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,

437: p_apply_position_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
438: p_create_positions IN VARCHAR2 := FND_API.G_MISS_CHAR,
439: p_create_summary_totals IN VARCHAR2 := FND_API.G_MISS_CHAR,
440: p_apply_constraints IN VARCHAR2 := FND_API.G_MISS_CHAR,
441: p_include_gl_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
442: p_include_gl_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
443: p_include_gl_other_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
444: p_include_cbc_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
445: p_include_cbc_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 442: p_include_gl_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,

438: p_create_positions IN VARCHAR2 := FND_API.G_MISS_CHAR,
439: p_create_summary_totals IN VARCHAR2 := FND_API.G_MISS_CHAR,
440: p_apply_constraints IN VARCHAR2 := FND_API.G_MISS_CHAR,
441: p_include_gl_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
442: p_include_gl_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
443: p_include_gl_other_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
444: p_include_cbc_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
445: p_include_cbc_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
446: p_include_cbc_budget_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 443: p_include_gl_other_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,

439: p_create_summary_totals IN VARCHAR2 := FND_API.G_MISS_CHAR,
440: p_apply_constraints IN VARCHAR2 := FND_API.G_MISS_CHAR,
441: p_include_gl_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
442: p_include_gl_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
443: p_include_gl_other_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
444: p_include_cbc_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
445: p_include_cbc_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
446: p_include_cbc_budget_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
447: /* For Bug No. 2312657 : Start */

Line 444: p_include_cbc_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,

440: p_apply_constraints IN VARCHAR2 := FND_API.G_MISS_CHAR,
441: p_include_gl_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
442: p_include_gl_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
443: p_include_gl_other_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
444: p_include_cbc_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
445: p_include_cbc_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
446: p_include_cbc_budget_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
447: /* For Bug No. 2312657 : Start */
448: p_gl_cutoff_period IN DATE := NULL,

Line 445: p_include_cbc_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,

441: p_include_gl_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
442: p_include_gl_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
443: p_include_gl_other_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
444: p_include_cbc_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
445: p_include_cbc_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
446: p_include_cbc_budget_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
447: /* For Bug No. 2312657 : Start */
448: p_gl_cutoff_period IN DATE := NULL,
449: p_gl_budget_set_id IN NUMBER := NULL,

Line 446: p_include_cbc_budget_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,

442: p_include_gl_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
443: p_include_gl_other_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
444: p_include_cbc_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
445: p_include_cbc_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
446: p_include_cbc_budget_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
447: /* For Bug No. 2312657 : Start */
448: p_gl_cutoff_period IN DATE := NULL,
449: p_gl_budget_set_id IN NUMBER := NULL,
450: /* For Bug No. 2312657 : End */

Line 451: p_federal_ws_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

447: /* For Bug No. 2312657 : Start */
448: p_gl_cutoff_period IN DATE := NULL,
449: p_gl_budget_set_id IN NUMBER := NULL,
450: /* For Bug No. 2312657 : End */
451: p_federal_ws_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
452: /* bug no 4725091 */
453: p_include_gl_forwd_balance IN VARCHAR2 := FND_API.G_MISS_CHAR
454: ) IS
455:

Line 453: p_include_gl_forwd_balance IN VARCHAR2 := FND_API.G_MISS_CHAR

449: p_gl_budget_set_id IN NUMBER := NULL,
450: /* For Bug No. 2312657 : End */
451: p_federal_ws_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
452: /* bug no 4725091 */
453: p_include_gl_forwd_balance IN VARCHAR2 := FND_API.G_MISS_CHAR
454: ) IS
455:
456: l_api_name CONSTANT VARCHAR2(30) := 'Update_Worksheet';
457: l_api_version CONSTANT NUMBER := 1.0;

Line 468: if not FND_API.Compatible_API_Call (l_api_version,

464:
465:
466: -- Standard call to check for call compatibility.
467:
468: if not FND_API.Compatible_API_Call (l_api_version,
469: p_api_version,
470: l_api_name,
471: G_PKG_NAME)
472: then

Line 473: raise FND_API.G_EXC_UNEXPECTED_ERROR;

469: p_api_version,
470: l_api_name,
471: G_PKG_NAME)
472: then
473: raise FND_API.G_EXC_UNEXPECTED_ERROR;
474: end if;
475:
476:
477: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 479: if FND_API.to_Boolean (p_init_msg_list) then

475:
476:
477: -- Initialize message list if p_init_msg_list is set to TRUE.
478:
479: if FND_API.to_Boolean (p_init_msg_list) then
480: FND_MSG_PUB.initialize;
481: end if;
482:
483:

Line 541: if FND_API.to_Boolean (p_commit) then

537: );
538:
539: -- Standard check of p_commit.
540:
541: if FND_API.to_Boolean (p_commit) then
542: commit work;
543: end if;
544:
545:

Line 553: when FND_API.G_EXC_ERROR then

549: p_data => p_msg_data);
550:
551: EXCEPTION
552:
553: when FND_API.G_EXC_ERROR then
554: rollback to Update_Worksheet_Pvt;
555: p_return_status := FND_API.G_RET_STS_ERROR;
556:
557: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 555: p_return_status := FND_API.G_RET_STS_ERROR;

551: EXCEPTION
552:
553: when FND_API.G_EXC_ERROR then
554: rollback to Update_Worksheet_Pvt;
555: p_return_status := FND_API.G_RET_STS_ERROR;
556:
557: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
558: p_data => p_msg_data);
559:

Line 560: when FND_API.G_EXC_UNEXPECTED_ERROR then

556:
557: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
558: p_data => p_msg_data);
559:
560: when FND_API.G_EXC_UNEXPECTED_ERROR then
561: rollback to Update_Worksheet_Pvt;
562: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
563:
564: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 562: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

558: p_data => p_msg_data);
559:
560: when FND_API.G_EXC_UNEXPECTED_ERROR then
561: rollback to Update_Worksheet_Pvt;
562: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
563:
564: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
565: p_data => p_msg_data);
566:

Line 569: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

565: p_data => p_msg_data);
566:
567: when OTHERS then
568: rollback to Update_Worksheet_Pvt;
569: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
570:
571: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
572: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
573: l_api_name);

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

581: /* ----------------------------------------------------------------------- */
582:
583: PROCEDURE Delete_Worksheet
584: ( p_api_version IN NUMBER,
585: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
586: p_commit IN VARCHAR2 := FND_API.G_FALSE,
587: p_return_status OUT NOCOPY VARCHAR2,
588: p_msg_count OUT NOCOPY NUMBER,
589: p_msg_data OUT NOCOPY VARCHAR2,

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

582:
583: PROCEDURE Delete_Worksheet
584: ( p_api_version IN NUMBER,
585: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
586: p_commit IN VARCHAR2 := FND_API.G_FALSE,
587: p_return_status OUT NOCOPY VARCHAR2,
588: p_msg_count OUT NOCOPY NUMBER,
589: p_msg_data OUT NOCOPY VARCHAR2,
590: p_worksheet_id IN NUMBER

Line 605: if not FND_API.Compatible_API_Call (l_api_version,

601:
602:
603: -- Standard call to check for call compatibility.
604:
605: if not FND_API.Compatible_API_Call (l_api_version,
606: p_api_version,
607: l_api_name,
608: G_PKG_NAME)
609: then

Line 610: raise FND_API.G_EXC_UNEXPECTED_ERROR;

606: p_api_version,
607: l_api_name,
608: G_PKG_NAME)
609: then
610: raise FND_API.G_EXC_UNEXPECTED_ERROR;
611: end if;
612:
613:
614: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 616: if FND_API.to_Boolean (p_init_msg_list) then

612:
613:
614: -- Initialize message list if p_init_msg_list is set to TRUE.
615:
616: if FND_API.to_Boolean (p_init_msg_list) then
617: FND_MSG_PUB.initialize;
618: end if;
619:
620:

Line 631: if FND_API.to_Boolean (p_commit) then

627:
628:
629: -- Standard check of p_commit.
630:
631: if FND_API.to_Boolean (p_commit) then
632: commit work;
633: end if;
634:
635:

Line 643: when FND_API.G_EXC_ERROR then

639: p_data => p_msg_data);
640:
641: EXCEPTION
642:
643: when FND_API.G_EXC_ERROR then
644: rollback to Delete_Worksheet_Pvt;
645: p_return_status := FND_API.G_RET_STS_ERROR;
646:
647: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 645: p_return_status := FND_API.G_RET_STS_ERROR;

641: EXCEPTION
642:
643: when FND_API.G_EXC_ERROR then
644: rollback to Delete_Worksheet_Pvt;
645: p_return_status := FND_API.G_RET_STS_ERROR;
646:
647: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
648: p_data => p_msg_data);
649:

Line 651: when FND_API.G_EXC_UNEXPECTED_ERROR then

647: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
648: p_data => p_msg_data);
649:
650:
651: when FND_API.G_EXC_UNEXPECTED_ERROR then
652: rollback to Delete_Worksheet_Pvt;
653: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
654:
655: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 653: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

649:
650:
651: when FND_API.G_EXC_UNEXPECTED_ERROR then
652: rollback to Delete_Worksheet_Pvt;
653: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
654:
655: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
656: p_data => p_msg_data);
657:

Line 661: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

657:
658:
659: when OTHERS then
660: rollback to Delete_Worksheet_Pvt;
661: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
662:
663: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
664: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
665: l_api_name);

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

674: /* ----------------------------------------------------------------------- */
675:
676: PROCEDURE Apply_Constraints
677: ( p_api_version IN NUMBER,
678: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
679: p_commit IN VARCHAR2 := FND_API.G_FALSE,
680: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
681: p_return_status OUT NOCOPY VARCHAR2,
682: p_msg_count OUT NOCOPY NUMBER,

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

675:
676: PROCEDURE Apply_Constraints
677: ( p_api_version IN NUMBER,
678: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
679: p_commit IN VARCHAR2 := FND_API.G_FALSE,
680: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
681: p_return_status OUT NOCOPY VARCHAR2,
682: p_msg_count OUT NOCOPY NUMBER,
683: p_msg_data OUT NOCOPY VARCHAR2,

Line 680: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,

676: PROCEDURE Apply_Constraints
677: ( p_api_version IN NUMBER,
678: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
679: p_commit IN VARCHAR2 := FND_API.G_FALSE,
680: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
681: p_return_status OUT NOCOPY VARCHAR2,
682: p_msg_count OUT NOCOPY NUMBER,
683: p_msg_data OUT NOCOPY VARCHAR2,
684: p_validation_status OUT NOCOPY VARCHAR2,

Line 686: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,

682: p_msg_count OUT NOCOPY NUMBER,
683: p_msg_data OUT NOCOPY VARCHAR2,
684: p_validation_status OUT NOCOPY VARCHAR2,
685: p_worksheet_id IN NUMBER,
686: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
687: p_flex_code IN NUMBER := FND_API.G_MISS_NUM,
688: p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR,
689: p_global_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
690: p_constraint_set_id IN NUMBER := FND_API.G_MISS_NUM,

Line 687: p_flex_code IN NUMBER := FND_API.G_MISS_NUM,

683: p_msg_data OUT NOCOPY VARCHAR2,
684: p_validation_status OUT NOCOPY VARCHAR2,
685: p_worksheet_id IN NUMBER,
686: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
687: p_flex_code IN NUMBER := FND_API.G_MISS_NUM,
688: p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR,
689: p_global_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
690: p_constraint_set_id IN NUMBER := FND_API.G_MISS_NUM,
691: p_constraint_set_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 688: p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR,

684: p_validation_status OUT NOCOPY VARCHAR2,
685: p_worksheet_id IN NUMBER,
686: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
687: p_flex_code IN NUMBER := FND_API.G_MISS_NUM,
688: p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR,
689: p_global_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
690: p_constraint_set_id IN NUMBER := FND_API.G_MISS_NUM,
691: p_constraint_set_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
692: p_constraint_set_threshold IN NUMBER := FND_API.G_MISS_NUM,

Line 689: p_global_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,

685: p_worksheet_id IN NUMBER,
686: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
687: p_flex_code IN NUMBER := FND_API.G_MISS_NUM,
688: p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR,
689: p_global_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
690: p_constraint_set_id IN NUMBER := FND_API.G_MISS_NUM,
691: p_constraint_set_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
692: p_constraint_set_threshold IN NUMBER := FND_API.G_MISS_NUM,
693: p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM,

Line 690: p_constraint_set_id IN NUMBER := FND_API.G_MISS_NUM,

686: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
687: p_flex_code IN NUMBER := FND_API.G_MISS_NUM,
688: p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR,
689: p_global_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
690: p_constraint_set_id IN NUMBER := FND_API.G_MISS_NUM,
691: p_constraint_set_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
692: p_constraint_set_threshold IN NUMBER := FND_API.G_MISS_NUM,
693: p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM,
694: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,

Line 691: p_constraint_set_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

687: p_flex_code IN NUMBER := FND_API.G_MISS_NUM,
688: p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR,
689: p_global_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
690: p_constraint_set_id IN NUMBER := FND_API.G_MISS_NUM,
691: p_constraint_set_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
692: p_constraint_set_threshold IN NUMBER := FND_API.G_MISS_NUM,
693: p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM,
694: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
695: p_business_group_id IN NUMBER := FND_API.G_MISS_NUM,

Line 692: p_constraint_set_threshold IN NUMBER := FND_API.G_MISS_NUM,

688: p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR,
689: p_global_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
690: p_constraint_set_id IN NUMBER := FND_API.G_MISS_NUM,
691: p_constraint_set_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
692: p_constraint_set_threshold IN NUMBER := FND_API.G_MISS_NUM,
693: p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM,
694: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
695: p_business_group_id IN NUMBER := FND_API.G_MISS_NUM,
696: p_budget_by_position IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 693: p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM,

689: p_global_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
690: p_constraint_set_id IN NUMBER := FND_API.G_MISS_NUM,
691: p_constraint_set_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
692: p_constraint_set_threshold IN NUMBER := FND_API.G_MISS_NUM,
693: p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM,
694: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
695: p_business_group_id IN NUMBER := FND_API.G_MISS_NUM,
696: p_budget_by_position IN VARCHAR2 := FND_API.G_MISS_CHAR
697: ) IS

Line 694: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,

690: p_constraint_set_id IN NUMBER := FND_API.G_MISS_NUM,
691: p_constraint_set_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
692: p_constraint_set_threshold IN NUMBER := FND_API.G_MISS_NUM,
693: p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM,
694: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
695: p_business_group_id IN NUMBER := FND_API.G_MISS_NUM,
696: p_budget_by_position IN VARCHAR2 := FND_API.G_MISS_CHAR
697: ) IS
698:

Line 695: p_business_group_id IN NUMBER := FND_API.G_MISS_NUM,

691: p_constraint_set_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
692: p_constraint_set_threshold IN NUMBER := FND_API.G_MISS_NUM,
693: p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM,
694: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
695: p_business_group_id IN NUMBER := FND_API.G_MISS_NUM,
696: p_budget_by_position IN VARCHAR2 := FND_API.G_MISS_CHAR
697: ) IS
698:
699: l_api_name CONSTANT VARCHAR2(30) := 'Apply_Constraints';

Line 696: p_budget_by_position IN VARCHAR2 := FND_API.G_MISS_CHAR

692: p_constraint_set_threshold IN NUMBER := FND_API.G_MISS_NUM,
693: p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM,
694: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
695: p_business_group_id IN NUMBER := FND_API.G_MISS_NUM,
696: p_budget_by_position IN VARCHAR2 := FND_API.G_MISS_CHAR
697: ) IS
698:
699: l_api_name CONSTANT VARCHAR2(30) := 'Apply_Constraints';
700: l_api_version CONSTANT NUMBER := 1.0;

Line 711: if not FND_API.Compatible_API_Call (l_api_version,

707:
708:
709: -- Standard call to check for call compatibility.
710:
711: if not FND_API.Compatible_API_Call (l_api_version,
712: p_api_version,
713: l_api_name,
714: G_PKG_NAME)
715: then

Line 716: raise FND_API.G_EXC_UNEXPECTED_ERROR;

712: p_api_version,
713: l_api_name,
714: G_PKG_NAME)
715: then
716: raise FND_API.G_EXC_UNEXPECTED_ERROR;
717:
718: end if;
719:
720:

Line 723: if FND_API.to_Boolean (p_init_msg_list) then

719:
720:
721: -- Initialize message list if p_init_msg_list is set to TRUE.
722:
723: if FND_API.to_Boolean (p_init_msg_list) then
724: FND_MSG_PUB.initialize;
725: end if;
726:
727:

Line 751: if FND_API.to_Boolean (p_commit) then

747:
748:
749: -- Standard check of p_commit.
750:
751: if FND_API.to_Boolean (p_commit) then
752: commit work;
753: end if;
754:
755:

Line 763: when FND_API.G_EXC_ERROR then

759: p_data => p_msg_data);
760:
761: EXCEPTION
762:
763: when FND_API.G_EXC_ERROR then
764: rollback to Apply_Constraints_Pvt;
765: p_return_status := FND_API.G_RET_STS_ERROR;
766:
767: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 765: p_return_status := FND_API.G_RET_STS_ERROR;

761: EXCEPTION
762:
763: when FND_API.G_EXC_ERROR then
764: rollback to Apply_Constraints_Pvt;
765: p_return_status := FND_API.G_RET_STS_ERROR;
766:
767: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
768: p_data => p_msg_data);
769:

Line 771: when FND_API.G_EXC_UNEXPECTED_ERROR then

767: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
768: p_data => p_msg_data);
769:
770:
771: when FND_API.G_EXC_UNEXPECTED_ERROR then
772: rollback to Apply_Constraints_Pvt;
773: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
774:
775: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 773: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

769:
770:
771: when FND_API.G_EXC_UNEXPECTED_ERROR then
772: rollback to Apply_Constraints_Pvt;
773: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
774:
775: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
776: p_data => p_msg_data);
777:

Line 781: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

777:
778:
779: when OTHERS then
780: rollback to Apply_Constraints_Pvt;
781: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
782:
783: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
784: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
785: l_api_name);

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

794: /* ----------------------------------------------------------------------- */
795:
796: PROCEDURE Validate_Entity_Set
797: ( p_api_version IN NUMBER,
798: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
799: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
800: p_return_status OUT NOCOPY VARCHAR2,
801: p_msg_count OUT NOCOPY NUMBER,
802: p_msg_data OUT NOCOPY VARCHAR2,

Line 799: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,

795:
796: PROCEDURE Validate_Entity_Set
797: ( p_api_version IN NUMBER,
798: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
799: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
800: p_return_status OUT NOCOPY VARCHAR2,
801: p_msg_count OUT NOCOPY NUMBER,
802: p_msg_data OUT NOCOPY VARCHAR2,
803: p_data_extract_id IN NUMBER,

Line 815: if not FND_API.Compatible_API_Call (l_api_version,

811: BEGIN
812:
813: -- Standard call to check for call compatibility.
814:
815: if not FND_API.Compatible_API_Call (l_api_version,
816: p_api_version,
817: l_api_name,
818: G_PKG_NAME)
819: then

Line 820: raise FND_API.G_EXC_UNEXPECTED_ERROR;

816: p_api_version,
817: l_api_name,
818: G_PKG_NAME)
819: then
820: raise FND_API.G_EXC_UNEXPECTED_ERROR;
821:
822: end if;
823:
824:

Line 827: if FND_API.to_Boolean (p_init_msg_list) then

823:
824:
825: -- Initialize message list if p_init_msg_list is set to TRUE.
826:
827: if FND_API.to_Boolean (p_init_msg_list) then
828: FND_MSG_PUB.initialize;
829: end if;
830:
831:

Line 850: when FND_API.G_EXC_ERROR then

846: p_data => p_msg_data);
847:
848: EXCEPTION
849:
850: when FND_API.G_EXC_ERROR then
851: p_return_status := FND_API.G_RET_STS_ERROR;
852:
853: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
854: p_data => p_msg_data);

Line 851: p_return_status := FND_API.G_RET_STS_ERROR;

847:
848: EXCEPTION
849:
850: when FND_API.G_EXC_ERROR then
851: p_return_status := FND_API.G_RET_STS_ERROR;
852:
853: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
854: p_data => p_msg_data);
855:

Line 857: when FND_API.G_EXC_UNEXPECTED_ERROR then

853: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
854: p_data => p_msg_data);
855:
856:
857: when FND_API.G_EXC_UNEXPECTED_ERROR then
858: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
859:
860: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
861: p_data => p_msg_data);

Line 858: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

854: p_data => p_msg_data);
855:
856:
857: when FND_API.G_EXC_UNEXPECTED_ERROR then
858: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
859:
860: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
861: p_data => p_msg_data);
862:

Line 865: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

861: p_data => p_msg_data);
862:
863:
864: when OTHERS then
865: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
866:
867: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
868: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
869: l_api_name);

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

878: /* ----------------------------------------------------------------------- */
879:
880: PROCEDURE Delete_WPL
881: ( p_api_version IN NUMBER,
882: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
883: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
884: p_return_status OUT NOCOPY VARCHAR2,
885: p_msg_count OUT NOCOPY NUMBER,
886: p_msg_data OUT NOCOPY VARCHAR2,

Line 883: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,

879:
880: PROCEDURE Delete_WPL
881: ( p_api_version IN NUMBER,
882: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
883: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
884: p_return_status OUT NOCOPY VARCHAR2,
885: p_msg_count OUT NOCOPY NUMBER,
886: p_msg_data OUT NOCOPY VARCHAR2,
887: p_worksheet_id IN NUMBER,

Line 902: if not FND_API.Compatible_API_Call (l_api_version,

898: SAVEPOINT Delete_WPL_Pvt;
899:
900: -- Standard call to check for call compatibility.
901:
902: if not FND_API.Compatible_API_Call (l_api_version,
903: p_api_version,
904: l_api_name,
905: G_PKG_NAME)
906: then

Line 907: raise FND_API.G_EXC_UNEXPECTED_ERROR;

903: p_api_version,
904: l_api_name,
905: G_PKG_NAME)
906: then
907: raise FND_API.G_EXC_UNEXPECTED_ERROR;
908:
909: end if;
910:
911:

Line 914: if FND_API.to_Boolean (p_init_msg_list) then

910:
911:
912: -- Initialize message list if p_init_msg_list is set to TRUE.
913:
914: if FND_API.to_Boolean (p_init_msg_list) then
915: FND_MSG_PUB.initialize;
916: end if;
917:
918:

Line 936: when FND_API.G_EXC_ERROR then

932: p_data => p_msg_data);
933:
934: EXCEPTION
935:
936: when FND_API.G_EXC_ERROR then
937: rollback to Delete_WPL_Pvt;
938: p_return_status := FND_API.G_RET_STS_ERROR;
939:
940: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 938: p_return_status := FND_API.G_RET_STS_ERROR;

934: EXCEPTION
935:
936: when FND_API.G_EXC_ERROR then
937: rollback to Delete_WPL_Pvt;
938: p_return_status := FND_API.G_RET_STS_ERROR;
939:
940: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
941: p_data => p_msg_data);
942:

Line 944: when FND_API.G_EXC_UNEXPECTED_ERROR then

940: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
941: p_data => p_msg_data);
942:
943:
944: when FND_API.G_EXC_UNEXPECTED_ERROR then
945: rollback to Delete_WPL_Pvt;
946: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
947:
948: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 946: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

942:
943:
944: when FND_API.G_EXC_UNEXPECTED_ERROR then
945: rollback to Delete_WPL_Pvt;
946: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
947:
948: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
949: p_data => p_msg_data);
950:

Line 954: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

950:
951:
952: when OTHERS then
953: rollback to Delete_WPL_Pvt;
954: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
955:
956: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
957: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
958: l_api_name);

Line 1041: p_init_msg_list => FND_API.G_TRUE,

1037: end loop;
1038:
1039: PSB_BUDGET_ACCOUNT_PVT.Populate_Budget_Accounts
1040: (p_api_version => 1.0,
1041: p_init_msg_list => FND_API.G_TRUE,
1042: p_commit => FND_API.G_TRUE,
1043: p_return_status => l_return_status,
1044: p_msg_count => l_msg_count,
1045: p_msg_data => l_msg_data,

Line 1042: p_commit => FND_API.G_TRUE,

1038:
1039: PSB_BUDGET_ACCOUNT_PVT.Populate_Budget_Accounts
1040: (p_api_version => 1.0,
1041: p_init_msg_list => FND_API.G_TRUE,
1042: p_commit => FND_API.G_TRUE,
1043: p_return_status => l_return_status,
1044: p_msg_count => l_msg_count,
1045: p_msg_data => l_msg_data,
1046: p_account_set_id => l_account_set_id

Line 1049: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1045: p_msg_data => l_msg_data,
1046: p_account_set_id => l_account_set_id
1047: );
1048:
1049: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1050: raise FND_API.G_EXC_ERROR;
1051: end if;
1052:
1053: PSB_BUDGET_GROUPS_PVT.Val_Budget_Group_Hierarchy

Line 1050: raise FND_API.G_EXC_ERROR;

1046: p_account_set_id => l_account_set_id
1047: );
1048:
1049: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1050: raise FND_API.G_EXC_ERROR;
1051: end if;
1052:
1053: PSB_BUDGET_GROUPS_PVT.Val_Budget_Group_Hierarchy
1054: (p_api_version => 1.0,

Line 1055: p_init_msg_list => FND_API.G_TRUE,

1051: end if;
1052:
1053: PSB_BUDGET_GROUPS_PVT.Val_Budget_Group_Hierarchy
1054: (p_api_version => 1.0,
1055: p_init_msg_list => FND_API.G_TRUE,
1056: p_return_status => l_return_status,
1057: p_msg_count => l_msg_count,
1058: p_msg_data => l_msg_data,
1059: p_budget_group_id => l_root_budget_group_id,

Line 1060: p_validate_ranges => FND_API.G_FALSE,

1056: p_return_status => l_return_status,
1057: p_msg_count => l_msg_count,
1058: p_msg_data => l_msg_data,
1059: p_budget_group_id => l_root_budget_group_id,
1060: p_validate_ranges => FND_API.G_FALSE,
1061: p_check_missing_acct => FND_API.G_FALSE);
1062:
1063: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1064: raise FND_API.G_EXC_ERROR;

Line 1061: p_check_missing_acct => FND_API.G_FALSE);

1057: p_msg_count => l_msg_count,
1058: p_msg_data => l_msg_data,
1059: p_budget_group_id => l_root_budget_group_id,
1060: p_validate_ranges => FND_API.G_FALSE,
1061: p_check_missing_acct => FND_API.G_FALSE);
1062:
1063: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1064: raise FND_API.G_EXC_ERROR;
1065: end if;

Line 1063: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1059: p_budget_group_id => l_root_budget_group_id,
1060: p_validate_ranges => FND_API.G_FALSE,
1061: p_check_missing_acct => FND_API.G_FALSE);
1062:
1063: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1064: raise FND_API.G_EXC_ERROR;
1065: end if;
1066: */
1067:

Line 1064: raise FND_API.G_EXC_ERROR;

1060: p_validate_ranges => FND_API.G_FALSE,
1061: p_check_missing_acct => FND_API.G_FALSE);
1062:
1063: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1064: raise FND_API.G_EXC_ERROR;
1065: end if;
1066: */
1067:
1068: PSB_BUDGET_POSITION_PVT.Populate_Budget_Positions

Line 1070: p_commit => FND_API.G_TRUE,

1066: */
1067:
1068: PSB_BUDGET_POSITION_PVT.Populate_Budget_Positions
1069: (p_api_version => 1.0,
1070: p_commit => FND_API.G_TRUE,
1071: p_return_status => l_return_status,
1072: p_msg_count => l_msg_count,
1073: p_msg_data => l_msg_data,
1074: p_data_extract_id => l_data_extract_id

Line 1077: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1073: p_msg_data => l_msg_data,
1074: p_data_extract_id => l_data_extract_id
1075: );
1076:
1077: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1078: raise FND_API.G_EXC_ERROR;
1079: end if;
1080:
1081: -- Validate data consistency for all Positions

Line 1078: raise FND_API.G_EXC_ERROR;

1074: p_data_extract_id => l_data_extract_id
1075: );
1076:
1077: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1078: raise FND_API.G_EXC_ERROR;
1079: end if;
1080:
1081: -- Validate data consistency for all Positions
1082:

Line 1092: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1088: p_worksheet_id => p_worksheet_id,
1089: p_validation_status => l_validation_status
1090: );
1091:
1092: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1093: raise FND_API.G_EXC_ERROR;
1094: end if;
1095:
1096: if l_validation_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1093: raise FND_API.G_EXC_ERROR;

1089: p_validation_status => l_validation_status
1090: );
1091:
1092: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1093: raise FND_API.G_EXC_ERROR;
1094: end if;
1095:
1096: if l_validation_status <> FND_API.G_RET_STS_SUCCESS THEN
1097: -- submit concurrent request for error report

Line 1096: if l_validation_status <> FND_API.G_RET_STS_SUCCESS THEN

1092: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1093: raise FND_API.G_EXC_ERROR;
1094: end if;
1095:
1096: if l_validation_status <> FND_API.G_RET_STS_SUCCESS THEN
1097: -- submit concurrent request for error report
1098: -- waiting for correction to error messages report
1099:
1100: l_rep_req_id := Fnd_Request.Submit_Request

Line 1126: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1122: p_msg_count => l_msg_count,
1123: p_msg_data => l_msg_data,
1124: p_worksheet_id => p_worksheet_id);
1125:
1126: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1127: raise FND_API.G_EXC_ERROR;
1128: end if;
1129:
1130: PSB_MESSAGE_S.Print_Success;

Line 1127: raise FND_API.G_EXC_ERROR;

1123: p_msg_data => l_msg_data,
1124: p_worksheet_id => p_worksheet_id);
1125:
1126: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1127: raise FND_API.G_EXC_ERROR;
1128: end if;
1129:
1130: PSB_MESSAGE_S.Print_Success;
1131: retcode := 0 ;

Line 1135: WHEN FND_API.G_EXC_ERROR THEN

1131: retcode := 0 ;
1132:
1133: EXCEPTION
1134:
1135: WHEN FND_API.G_EXC_ERROR THEN
1136: --
1137: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1138: p_print_header => FND_API.G_TRUE );
1139: retcode := 2 ;

Line 1138: p_print_header => FND_API.G_TRUE );

1134:
1135: WHEN FND_API.G_EXC_ERROR THEN
1136: --
1137: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1138: p_print_header => FND_API.G_TRUE );
1139: retcode := 2 ;
1140: COMMIT WORK ;
1141: --
1142: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1142: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1138: p_print_header => FND_API.G_TRUE );
1139: retcode := 2 ;
1140: COMMIT WORK ;
1141: --
1142: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1143: --
1144: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1145: p_print_header => FND_API.G_TRUE );
1146: retcode := 2 ;

Line 1145: p_print_header => FND_API.G_TRUE );

1141: --
1142: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1143: --
1144: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1145: p_print_header => FND_API.G_TRUE );
1146: retcode := 2 ;
1147: COMMIT WORK ;
1148: --
1149: WHEN OTHERS THEN

Line 1157: l_return_status := FND_API.G_RET_STS_ERROR;

1153: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
1154: l_api_name ) ;
1155: END IF ;
1156: --
1157: l_return_status := FND_API.G_RET_STS_ERROR;
1158:
1159: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1160: p_print_header => FND_API.G_TRUE );
1161: --

Line 1160: p_print_header => FND_API.G_TRUE );

1156: --
1157: l_return_status := FND_API.G_RET_STS_ERROR;
1158:
1159: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1160: p_print_header => FND_API.G_TRUE );
1161: --
1162: retcode := 2 ;
1163: COMMIT WORK ;
1164: --

Line 1209: p_init_msg_list => FND_API.G_TRUE ,

1205:
1206: PSB_Budget_Account_PVT.Populate_Budget_Accounts
1207: (
1208: p_api_version => 1.0 ,
1209: p_init_msg_list => FND_API.G_TRUE ,
1210: p_commit => FND_API.G_FALSE ,
1211: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
1212: p_return_status => l_return_status ,
1213: p_msg_count => l_msg_count ,

Line 1210: p_commit => FND_API.G_FALSE ,

1206: PSB_Budget_Account_PVT.Populate_Budget_Accounts
1207: (
1208: p_api_version => 1.0 ,
1209: p_init_msg_list => FND_API.G_TRUE ,
1210: p_commit => FND_API.G_FALSE ,
1211: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
1212: p_return_status => l_return_status ,
1213: p_msg_count => l_msg_count ,
1214: p_msg_data => l_msg_data ,

Line 1211: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,

1207: (
1208: p_api_version => 1.0 ,
1209: p_init_msg_list => FND_API.G_TRUE ,
1210: p_commit => FND_API.G_FALSE ,
1211: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
1212: p_return_status => l_return_status ,
1213: p_msg_count => l_msg_count ,
1214: p_msg_data => l_msg_data ,
1215: -- Bug 3458191: Pass set of books id

Line 1219: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1215: -- Bug 3458191: Pass set of books id
1216: p_set_of_books_id => l_set_of_books_id
1217: );
1218:
1219: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1220: raise FND_API.G_EXC_ERROR;
1221: end if;
1222:
1223: PSB_BUDGET_GROUPS_PVT.Val_Budget_Group_Hierarchy

Line 1220: raise FND_API.G_EXC_ERROR;

1216: p_set_of_books_id => l_set_of_books_id
1217: );
1218:
1219: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1220: raise FND_API.G_EXC_ERROR;
1221: end if;
1222:
1223: PSB_BUDGET_GROUPS_PVT.Val_Budget_Group_Hierarchy
1224: (

Line 1226: p_init_msg_list => FND_API.G_TRUE,

1222:
1223: PSB_BUDGET_GROUPS_PVT.Val_Budget_Group_Hierarchy
1224: (
1225: p_api_version => 1.0,
1226: p_init_msg_list => FND_API.G_TRUE,
1227: p_return_status => l_return_status,
1228: p_msg_count => l_msg_count,
1229: p_msg_data => l_msg_data,
1230: p_budget_group_id => l_root_budget_group_id,

Line 1231: p_validate_ranges => FND_API.G_FALSE,

1227: p_return_status => l_return_status,
1228: p_msg_count => l_msg_count,
1229: p_msg_data => l_msg_data,
1230: p_budget_group_id => l_root_budget_group_id,
1231: p_validate_ranges => FND_API.G_FALSE,
1232: p_check_missing_acct => FND_API.G_FALSE
1233: );
1234:
1235: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1232: p_check_missing_acct => FND_API.G_FALSE

1228: p_msg_count => l_msg_count,
1229: p_msg_data => l_msg_data,
1230: p_budget_group_id => l_root_budget_group_id,
1231: p_validate_ranges => FND_API.G_FALSE,
1232: p_check_missing_acct => FND_API.G_FALSE
1233: );
1234:
1235: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1236: raise FND_API.G_EXC_ERROR;

Line 1235: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1231: p_validate_ranges => FND_API.G_FALSE,
1232: p_check_missing_acct => FND_API.G_FALSE
1233: );
1234:
1235: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1236: raise FND_API.G_EXC_ERROR;
1237: end if;
1238:
1239: PSB_MESSAGE_S.Print_Success;

Line 1236: raise FND_API.G_EXC_ERROR;

1232: p_check_missing_acct => FND_API.G_FALSE
1233: );
1234:
1235: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1236: raise FND_API.G_EXC_ERROR;
1237: end if;
1238:
1239: PSB_MESSAGE_S.Print_Success;
1240: retcode := 0 ;

Line 1244: WHEN FND_API.G_EXC_ERROR THEN

1240: retcode := 0 ;
1241:
1242: EXCEPTION
1243:
1244: WHEN FND_API.G_EXC_ERROR THEN
1245: --
1246: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1247: p_print_header => FND_API.G_TRUE );
1248: retcode := 2 ;

Line 1247: p_print_header => FND_API.G_TRUE );

1243:
1244: WHEN FND_API.G_EXC_ERROR THEN
1245: --
1246: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1247: p_print_header => FND_API.G_TRUE );
1248: retcode := 2 ;
1249: COMMIT WORK ;
1250: --
1251: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1251: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1247: p_print_header => FND_API.G_TRUE );
1248: retcode := 2 ;
1249: COMMIT WORK ;
1250: --
1251: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1252: --
1253: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1254: p_print_header => FND_API.G_TRUE );
1255: retcode := 2 ;

Line 1254: p_print_header => FND_API.G_TRUE );

1250: --
1251: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1252: --
1253: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1254: p_print_header => FND_API.G_TRUE );
1255: retcode := 2 ;
1256: COMMIT WORK ;
1257: --
1258: WHEN OTHERS THEN

Line 1267: l_return_status := FND_API.G_RET_STS_ERROR;

1263: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
1264: l_api_name ) ;
1265: END IF ;
1266: --
1267: l_return_status := FND_API.G_RET_STS_ERROR;
1268:
1269: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1270: p_print_header => FND_API.G_TRUE );
1271: --

Line 1270: p_print_header => FND_API.G_TRUE );

1266: --
1267: l_return_status := FND_API.G_RET_STS_ERROR;
1268:
1269: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1270: p_print_header => FND_API.G_TRUE );
1271: --
1272: retcode := 2 ;
1273: COMMIT WORK ;
1274: --

Line 1304: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1300: (p_api_version => 1.0,
1301: p_return_status => l_return_status,
1302: p_worksheet_id => p_worksheet_id);
1303:
1304: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1305: raise FND_API.G_EXC_ERROR;
1306: end if;
1307:
1308: PSB_MESSAGE_S.Print_Success;

Line 1305: raise FND_API.G_EXC_ERROR;

1301: p_return_status => l_return_status,
1302: p_worksheet_id => p_worksheet_id);
1303:
1304: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1305: raise FND_API.G_EXC_ERROR;
1306: end if;
1307:
1308: PSB_MESSAGE_S.Print_Success;
1309: retcode := 0 ;

Line 1313: WHEN FND_API.G_EXC_ERROR THEN

1309: retcode := 0 ;
1310:
1311: EXCEPTION
1312:
1313: WHEN FND_API.G_EXC_ERROR THEN
1314: --
1315: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1316: p_print_header => FND_API.G_TRUE );
1317: retcode := 2 ;

Line 1316: p_print_header => FND_API.G_TRUE );

1312:
1313: WHEN FND_API.G_EXC_ERROR THEN
1314: --
1315: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1316: p_print_header => FND_API.G_TRUE );
1317: retcode := 2 ;
1318: COMMIT WORK ;
1319: --
1320: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1320: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1316: p_print_header => FND_API.G_TRUE );
1317: retcode := 2 ;
1318: COMMIT WORK ;
1319: --
1320: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1321: --
1322: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1323: p_print_header => FND_API.G_TRUE );
1324: retcode := 2 ;

Line 1323: p_print_header => FND_API.G_TRUE );

1319: --
1320: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1321: --
1322: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1323: p_print_header => FND_API.G_TRUE );
1324: retcode := 2 ;
1325: COMMIT WORK ;
1326: --
1327: WHEN OTHERS THEN

Line 1336: l_return_status := FND_API.G_RET_STS_ERROR;

1332: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
1333: l_api_name ) ;
1334: END IF ;
1335: --
1336: l_return_status := FND_API.G_RET_STS_ERROR;
1337:
1338: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1339: p_print_header => FND_API.G_TRUE );
1340: --

Line 1339: p_print_header => FND_API.G_TRUE );

1335: --
1336: l_return_status := FND_API.G_RET_STS_ERROR;
1337:
1338: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1339: p_print_header => FND_API.G_TRUE );
1340: --
1341: retcode := 2 ;
1342: COMMIT WORK ;
1343: --

Line 1388: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1384:
1385: -- Bug 3458191: Reset g_worksheet_creation_flag to FALSE
1386: PSB_WORKSHEET.g_ws_creation_flag := FALSE;
1387:
1388: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1389: raise FND_API.G_EXC_ERROR;
1390: end if;
1391:
1392: END IF;

Line 1389: raise FND_API.G_EXC_ERROR;

1385: -- Bug 3458191: Reset g_worksheet_creation_flag to FALSE
1386: PSB_WORKSHEET.g_ws_creation_flag := FALSE;
1387:
1388: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1389: raise FND_API.G_EXC_ERROR;
1390: end if;
1391:
1392: END IF;
1393:

Line 1404: p_print_header => FND_API.G_FALSE);

1400: l_msg_buf := FND_Message.Get;
1401: FND_FILE.Put_Line(FND_FILE.LOG, l_msg_buf);
1402:
1403: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG,
1404: p_print_header => FND_API.G_FALSE);
1405: end if;
1406: /* Bug No 2550186 End */
1407:
1408: PSB_MESSAGE_S.Print_Success;

Line 1422: WHEN FND_API.G_EXC_ERROR THEN

1418: retcode := 0 ;
1419:
1420: EXCEPTION
1421:
1422: WHEN FND_API.G_EXC_ERROR THEN
1423: --
1424: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1425: p_print_header => FND_API.G_TRUE );
1426: retcode := 2 ;

Line 1425: p_print_header => FND_API.G_TRUE );

1421:
1422: WHEN FND_API.G_EXC_ERROR THEN
1423: --
1424: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1425: p_print_header => FND_API.G_TRUE );
1426: retcode := 2 ;
1427: COMMIT WORK ;
1428: --
1429: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1429: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1425: p_print_header => FND_API.G_TRUE );
1426: retcode := 2 ;
1427: COMMIT WORK ;
1428: --
1429: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1430: --
1431: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1432: p_print_header => FND_API.G_TRUE );
1433: retcode := 2 ;

Line 1432: p_print_header => FND_API.G_TRUE );

1428: --
1429: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1430: --
1431: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1432: p_print_header => FND_API.G_TRUE );
1433: retcode := 2 ;
1434: COMMIT WORK ;
1435: --
1436: WHEN OTHERS THEN

Line 1445: l_return_status := FND_API.G_RET_STS_ERROR;

1441: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
1442: l_api_name ) ;
1443: END IF ;
1444: --
1445: l_return_status := FND_API.G_RET_STS_ERROR;
1446:
1447: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1448: p_print_header => FND_API.G_TRUE );
1449: --

Line 1448: p_print_header => FND_API.G_TRUE );

1444: --
1445: l_return_status := FND_API.G_RET_STS_ERROR;
1446:
1447: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1448: p_print_header => FND_API.G_TRUE );
1449: --
1450: retcode := 2 ;
1451: COMMIT WORK ;
1452: --

Line 1485: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1481: (p_api_version => 1.0,
1482: p_return_status => l_return_status,
1483: p_worksheet_id => p_worksheet_id);
1484:
1485: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1486: raise FND_API.G_EXC_ERROR;
1487: end if;
1488:
1489: ELSE

Line 1486: raise FND_API.G_EXC_ERROR;

1482: p_return_status => l_return_status,
1483: p_worksheet_id => p_worksheet_id);
1484:
1485: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1486: raise FND_API.G_EXC_ERROR;
1487: end if;
1488:
1489: ELSE
1490:

Line 1500: WHEN FND_API.G_EXC_ERROR THEN

1496: retcode := 0 ;
1497:
1498: EXCEPTION
1499:
1500: WHEN FND_API.G_EXC_ERROR THEN
1501: --
1502: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1503: p_print_header => FND_API.G_TRUE );
1504: retcode := 2 ;

Line 1503: p_print_header => FND_API.G_TRUE );

1499:
1500: WHEN FND_API.G_EXC_ERROR THEN
1501: --
1502: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1503: p_print_header => FND_API.G_TRUE );
1504: retcode := 2 ;
1505: COMMIT WORK ;
1506: --
1507: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1507: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1503: p_print_header => FND_API.G_TRUE );
1504: retcode := 2 ;
1505: COMMIT WORK ;
1506: --
1507: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1508: --
1509: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1510: p_print_header => FND_API.G_TRUE );
1511: retcode := 2 ;

Line 1510: p_print_header => FND_API.G_TRUE );

1506: --
1507: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1508: --
1509: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1510: p_print_header => FND_API.G_TRUE );
1511: retcode := 2 ;
1512: COMMIT WORK ;
1513: --
1514: WHEN OTHERS THEN

Line 1523: l_return_status := FND_API.G_RET_STS_ERROR;

1519: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
1520: l_api_name ) ;
1521: END IF ;
1522: --
1523: l_return_status := FND_API.G_RET_STS_ERROR;
1524:
1525: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1526: p_print_header => FND_API.G_TRUE );
1527: --

Line 1526: p_print_header => FND_API.G_TRUE );

1522: --
1523: l_return_status := FND_API.G_RET_STS_ERROR;
1524:
1525: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1526: p_print_header => FND_API.G_TRUE );
1527: --
1528: retcode := 2 ;
1529: COMMIT WORK ;
1530: --

Line 1565: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1561: (p_api_version => 1.0,
1562: p_return_status => l_return_status,
1563: p_worksheet_id => p_worksheet_id);
1564:
1565: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1566: raise FND_API.G_EXC_ERROR;
1567: end if;
1568:
1569: ELSE

Line 1566: raise FND_API.G_EXC_ERROR;

1562: p_return_status => l_return_status,
1563: p_worksheet_id => p_worksheet_id);
1564:
1565: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1566: raise FND_API.G_EXC_ERROR;
1567: end if;
1568:
1569: ELSE
1570:

Line 1580: WHEN FND_API.G_EXC_ERROR THEN

1576: retcode := 0 ;
1577:
1578: EXCEPTION
1579:
1580: WHEN FND_API.G_EXC_ERROR THEN
1581: --
1582: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1583: p_print_header => FND_API.G_TRUE );
1584: retcode := 2 ;

Line 1583: p_print_header => FND_API.G_TRUE );

1579:
1580: WHEN FND_API.G_EXC_ERROR THEN
1581: --
1582: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1583: p_print_header => FND_API.G_TRUE );
1584: retcode := 2 ;
1585: COMMIT WORK ;
1586: --
1587: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1587: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1583: p_print_header => FND_API.G_TRUE );
1584: retcode := 2 ;
1585: COMMIT WORK ;
1586: --
1587: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1588: --
1589: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1590: p_print_header => FND_API.G_TRUE );
1591: retcode := 2 ;

Line 1590: p_print_header => FND_API.G_TRUE );

1586: --
1587: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1588: --
1589: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1590: p_print_header => FND_API.G_TRUE );
1591: retcode := 2 ;
1592: COMMIT WORK ;
1593: --
1594: WHEN OTHERS THEN

Line 1603: l_return_status := FND_API.G_RET_STS_ERROR;

1599: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
1600: l_api_name ) ;
1601: END IF ;
1602: --
1603: l_return_status := FND_API.G_RET_STS_ERROR;
1604:
1605: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1606: p_print_header => FND_API.G_TRUE );
1607: --

Line 1606: p_print_header => FND_API.G_TRUE );

1602: --
1603: l_return_status := FND_API.G_RET_STS_ERROR;
1604:
1605: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1606: p_print_header => FND_API.G_TRUE );
1607: --
1608: retcode := 2 ;
1609: COMMIT WORK ;
1610: --

Line 1645: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1641: (p_api_version => 1.0,
1642: p_return_status => l_return_status,
1643: p_worksheet_id => p_worksheet_id);
1644:
1645: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1646: raise FND_API.G_EXC_ERROR;
1647: end if;
1648:
1649: ELSE

Line 1646: raise FND_API.G_EXC_ERROR;

1642: p_return_status => l_return_status,
1643: p_worksheet_id => p_worksheet_id);
1644:
1645: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1646: raise FND_API.G_EXC_ERROR;
1647: end if;
1648:
1649: ELSE
1650:

Line 1660: WHEN FND_API.G_EXC_ERROR THEN

1656: retcode := 0 ;
1657:
1658: EXCEPTION
1659:
1660: WHEN FND_API.G_EXC_ERROR THEN
1661: --
1662: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1663: p_print_header => FND_API.G_TRUE );
1664: retcode := 2 ;

Line 1663: p_print_header => FND_API.G_TRUE );

1659:
1660: WHEN FND_API.G_EXC_ERROR THEN
1661: --
1662: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1663: p_print_header => FND_API.G_TRUE );
1664: retcode := 2 ;
1665: COMMIT WORK ;
1666: --
1667: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1667: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1663: p_print_header => FND_API.G_TRUE );
1664: retcode := 2 ;
1665: COMMIT WORK ;
1666: --
1667: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1668: --
1669: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1670: p_print_header => FND_API.G_TRUE );
1671: retcode := 2 ;

Line 1670: p_print_header => FND_API.G_TRUE );

1666: --
1667: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1668: --
1669: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1670: p_print_header => FND_API.G_TRUE );
1671: retcode := 2 ;
1672: COMMIT WORK ;
1673: --
1674: WHEN OTHERS THEN

Line 1683: l_return_status := FND_API.G_RET_STS_ERROR;

1679: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
1680: l_api_name ) ;
1681: END IF ;
1682: --
1683: l_return_status := FND_API.G_RET_STS_ERROR;
1684:
1685: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1686: p_print_header => FND_API.G_TRUE );
1687: --

Line 1686: p_print_header => FND_API.G_TRUE );

1682: --
1683: l_return_status := FND_API.G_RET_STS_ERROR;
1684:
1685: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1686: p_print_header => FND_API.G_TRUE );
1687: --
1688: retcode := 2 ;
1689: COMMIT WORK ;
1690: --

Line 1726: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1722: (p_api_version => 1.0,
1723: p_return_status => l_return_status,
1724: p_worksheet_id => p_worksheet_id);
1725:
1726: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1727: raise FND_API.G_EXC_ERROR;
1728: end if;
1729:
1730: ELSE

Line 1727: raise FND_API.G_EXC_ERROR;

1723: p_return_status => l_return_status,
1724: p_worksheet_id => p_worksheet_id);
1725:
1726: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1727: raise FND_API.G_EXC_ERROR;
1728: end if;
1729:
1730: ELSE
1731:

Line 1741: WHEN FND_API.G_EXC_ERROR THEN

1737: retcode := 0 ;
1738:
1739: EXCEPTION
1740:
1741: WHEN FND_API.G_EXC_ERROR THEN
1742: --
1743: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1744: p_print_header => FND_API.G_TRUE );
1745: retcode := 2 ;

Line 1744: p_print_header => FND_API.G_TRUE );

1740:
1741: WHEN FND_API.G_EXC_ERROR THEN
1742: --
1743: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1744: p_print_header => FND_API.G_TRUE );
1745: retcode := 2 ;
1746: COMMIT WORK ;
1747: --
1748: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1748: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1744: p_print_header => FND_API.G_TRUE );
1745: retcode := 2 ;
1746: COMMIT WORK ;
1747: --
1748: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1749: --
1750: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1751: p_print_header => FND_API.G_TRUE );
1752: retcode := 2 ;

Line 1751: p_print_header => FND_API.G_TRUE );

1747: --
1748: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1749: --
1750: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1751: p_print_header => FND_API.G_TRUE );
1752: retcode := 2 ;
1753: COMMIT WORK ;
1754: --
1755: WHEN OTHERS THEN

Line 1764: l_return_status := FND_API.G_RET_STS_ERROR;

1760: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
1761: l_api_name ) ;
1762: END IF ;
1763: --
1764: l_return_status := FND_API.G_RET_STS_ERROR;
1765:
1766: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1767: p_print_header => FND_API.G_TRUE );
1768: --

Line 1767: p_print_header => FND_API.G_TRUE );

1763: --
1764: l_return_status := FND_API.G_RET_STS_ERROR;
1765:
1766: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1767: p_print_header => FND_API.G_TRUE );
1768: --
1769: retcode := 2 ;
1770: COMMIT WORK ;
1771: --

Line 1801: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1797: (p_api_version => 1.0,
1798: p_return_status => l_return_status,
1799: p_worksheet_id => p_worksheet_id);
1800:
1801: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1802: raise FND_API.G_EXC_ERROR;
1803: end if;
1804:
1805: PSB_MESSAGE_S.Print_Success;

Line 1802: raise FND_API.G_EXC_ERROR;

1798: p_return_status => l_return_status,
1799: p_worksheet_id => p_worksheet_id);
1800:
1801: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1802: raise FND_API.G_EXC_ERROR;
1803: end if;
1804:
1805: PSB_MESSAGE_S.Print_Success;
1806: retcode := 0 ;

Line 1810: WHEN FND_API.G_EXC_ERROR THEN

1806: retcode := 0 ;
1807:
1808: EXCEPTION
1809:
1810: WHEN FND_API.G_EXC_ERROR THEN
1811: --
1812: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1813: p_print_header => FND_API.G_TRUE );
1814: retcode := 2 ;

Line 1813: p_print_header => FND_API.G_TRUE );

1809:
1810: WHEN FND_API.G_EXC_ERROR THEN
1811: --
1812: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1813: p_print_header => FND_API.G_TRUE );
1814: retcode := 2 ;
1815: COMMIT WORK ;
1816: --
1817: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1817: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1813: p_print_header => FND_API.G_TRUE );
1814: retcode := 2 ;
1815: COMMIT WORK ;
1816: --
1817: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1818: --
1819: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1820: p_print_header => FND_API.G_TRUE );
1821: retcode := 2 ;

Line 1820: p_print_header => FND_API.G_TRUE );

1816: --
1817: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1818: --
1819: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1820: p_print_header => FND_API.G_TRUE );
1821: retcode := 2 ;
1822: COMMIT WORK ;
1823: --
1824: WHEN OTHERS THEN

Line 1833: l_return_status := FND_API.G_RET_STS_ERROR;

1829: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
1830: l_api_name ) ;
1831: END IF ;
1832: --
1833: l_return_status := FND_API.G_RET_STS_ERROR;
1834:
1835: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1836: p_print_header => FND_API.G_TRUE );
1837: --

Line 1836: p_print_header => FND_API.G_TRUE );

1832: --
1833: l_return_status := FND_API.G_RET_STS_ERROR;
1834:
1835: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1836: p_print_header => FND_API.G_TRUE );
1837: --
1838: retcode := 2 ;
1839: COMMIT WORK ;
1840: --