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

Line 112: p_stage_id IN NUMBER := FND_API.G_MISS_NUM

108: PROCEDURE Setup_Year_View
109: (
110: p_worksheet_id IN NUMBER,
111: p_user_id IN NUMBER,
112: p_stage_id IN NUMBER := FND_API.G_MISS_NUM
113: );
114:
115: -- Routines used by Setup_Year_View
116: FUNCTION Get_Current_Stage_Seq RETURN NUMBER;

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

121: /* ---------------Exposed Packages---------------- */
122: PROCEDURE Move_To_Interface
123: (
124: p_api_version IN NUMBER ,
125: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
126: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
127: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
128: p_return_status OUT NOCOPY VARCHAR2 ,
129: p_msg_count OUT NOCOPY NUMBER ,

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

122: PROCEDURE Move_To_Interface
123: (
124: p_api_version IN NUMBER ,
125: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
126: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
127: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
128: p_return_status OUT NOCOPY VARCHAR2 ,
129: p_msg_count OUT NOCOPY NUMBER ,
130: p_msg_data OUT NOCOPY VARCHAR2 ,

Line 127: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

123: (
124: p_api_version IN NUMBER ,
125: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
126: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
127: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
128: p_return_status OUT NOCOPY VARCHAR2 ,
129: p_msg_count OUT NOCOPY NUMBER ,
130: p_msg_data OUT NOCOPY VARCHAR2 ,
131: --

Line 134: p_stage_id IN NUMBER := FND_API.G_MISS_NUM,

130: p_msg_data OUT NOCOPY VARCHAR2 ,
131: --
132: p_export_name IN VARCHAR2,
133: p_worksheet_id IN NUMBER,
134: p_stage_id IN NUMBER := FND_API.G_MISS_NUM,
135: p_export_worksheet_type IN VARCHAR2 := FND_API.G_MISS_CHAR
136:
137: )
138: IS

Line 135: p_export_worksheet_type IN VARCHAR2 := FND_API.G_MISS_CHAR

131: --
132: p_export_name IN VARCHAR2,
133: p_worksheet_id IN NUMBER,
134: p_stage_id IN NUMBER := FND_API.G_MISS_NUM,
135: p_export_worksheet_type IN VARCHAR2 := FND_API.G_MISS_CHAR
136:
137: )
138: IS
139:

Line 164: IF NOT FND_API.Compatible_API_Call ( l_api_version,

160: --dbms_output.put_line('Exporting ...');
161: --
162: SAVEPOINT Move_To_Interface_Pvt ;
163: --
164: IF NOT FND_API.Compatible_API_Call ( l_api_version,
165: p_api_version,
166: l_api_name,
167: G_PKG_NAME )
168: THEN

Line 169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

165: p_api_version,
166: l_api_name,
167: G_PKG_NAME )
168: THEN
169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
170: END IF;
171: --
172:
173: IF FND_API.To_Boolean ( p_init_msg_list ) THEN

Line 173: IF FND_API.To_Boolean ( p_init_msg_list ) THEN

169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
170: END IF;
171: --
172:
173: IF FND_API.To_Boolean ( p_init_msg_list ) THEN
174: FND_MSG_PUB.initialize ;
175: END IF;
176: --
177: p_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 177: p_return_status := FND_API.G_RET_STS_SUCCESS ;

173: IF FND_API.To_Boolean ( p_init_msg_list ) THEN
174: FND_MSG_PUB.initialize ;
175: END IF;
176: --
177: p_return_status := FND_API.G_RET_STS_SUCCESS ;
178:
179: l_ws_rec_found := FALSE;
180: FOR ws_recinfo IN
181: (SELECT nvl(global_worksheet_id,worksheet_id) global_worksheet_id,

Line 205: RAISE FND_API.G_EXC_ERROR ;

201: IF NOT l_ws_rec_found THEN
202: FND_MESSAGE.SET_NAME('PSB', 'PSB_INVALID_ARGUMENT');
203: FND_MESSAGE.SET_TOKEN('ROUTINE', 'Export Worksheet Procedure' );
204: FND_MSG_PUB.Add;
205: RAISE FND_API.G_EXC_ERROR ;
206: END IF;
207:
208: g_worksheet_id := p_worksheet_id;
209: g_user_id := FND_GLOBAL.USER_ID;

Line 228: IF p_export_worksheet_type = FND_API.G_MISS_CHAR THEN

224: -- comment line above when running from conc. manager
225: l_export_accounts := FALSE;
226: l_export_positions := FALSE;
227:
228: IF p_export_worksheet_type = FND_API.G_MISS_CHAR THEN
229: l_export_worksheet_type := 'B';
230: ELSE
231: l_export_worksheet_type := p_export_worksheet_type;
232: END IF;

Line 250: RAISE FND_API.G_EXC_ERROR;

246: ( not l_export_positions) THEN
247: FND_MESSAGE.SET_NAME('PSB', 'PSB_INVALID_ARGUMENT');
248: FND_MESSAGE.SET_TOKEN('ROUTINE', 'Export Worksheet Procedure' );
249: FND_MSG_PUB.Add;
250: RAISE FND_API.G_EXC_ERROR;
251: END IF;
252:
253: -- Set the correct worksheet type
254: IF l_export_accounts and l_export_positions THEN

Line 285: IF ( p_stage_id = FND_API.G_MISS_NUM) or (p_stage_id IS NULL) THEN

281: IF g_template_id IS NOT NULL THEN
282: g_allow_account_import := 'N';
283: END IF;
284:
285: IF ( p_stage_id = FND_API.G_MISS_NUM) or (p_stage_id IS NULL) THEN
286: g_stage_id := 0;
287: ELSE
288: g_allow_position_import := 'N';
289: g_allow_account_import := 'N';

Line 352: IF FND_API.to_Boolean (p_commit) then

348: update psb_worksheets_i
349: set allow_position_import = g_allow_position_import
350: where export_id = g_export_id;
351:
352: IF FND_API.to_Boolean (p_commit) then
353: commit work;
354: END IF;
355:
356:

Line 360: WHEN FND_API.G_EXC_ERROR THEN

356:
357: EXCEPTION
358:
359: --
360: WHEN FND_API.G_EXC_ERROR THEN
361:
362: ROLLBACK TO Move_To_Interface_Pvt;
363: p_return_status := FND_API.G_RET_STS_ERROR;
364: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 363: p_return_status := FND_API.G_RET_STS_ERROR;

359: --
360: WHEN FND_API.G_EXC_ERROR THEN
361:
362: ROLLBACK TO Move_To_Interface_Pvt;
363: p_return_status := FND_API.G_RET_STS_ERROR;
364: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
365: p_data => p_msg_data );
366: --
367: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 367: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

363: p_return_status := FND_API.G_RET_STS_ERROR;
364: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
365: p_data => p_msg_data );
366: --
367: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
368:
369: ROLLBACK TO Move_To_Interface_Pvt;
370: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
371: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 370: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

366: --
367: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
368:
369: ROLLBACK TO Move_To_Interface_Pvt;
370: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
371: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
372: p_data => p_msg_data );
373: --
374: WHEN OTHERS THEN

Line 376: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

372: p_data => p_msg_data );
373: --
374: WHEN OTHERS THEN
375: ROLLBACK TO Move_To_Interface_Pvt;
376: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
377: --
378: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
379: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
380: l_api_name);

Line 485: p_stage_id IN NUMBER := FND_API.G_MISS_NUM

481: PROCEDURE Setup_Year_View
482: (
483: p_worksheet_id IN NUMBER,
484: p_user_id IN NUMBER,
485: p_stage_id IN NUMBER := FND_API.G_MISS_NUM
486: ) IS
487:
488: BEGIN
489:

Line 1157: p_init_msg_list => FND_API.G_TRUE,

1153: BEGIN
1154: PSB_WS_ACCT_PVT.CHECK_CCID_TYPE
1155: (
1156: p_api_version => 1.0,
1157: p_init_msg_list => FND_API.G_TRUE,
1158: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1159: p_return_status => l_return_status,
1160: p_msg_count => l_msg_count,
1161: p_msg_data => l_msg_data,

Line 1158: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1154: PSB_WS_ACCT_PVT.CHECK_CCID_TYPE
1155: (
1156: p_api_version => 1.0,
1157: p_init_msg_list => FND_API.G_TRUE,
1158: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1159: p_return_status => l_return_status,
1160: p_msg_count => l_msg_count,
1161: p_msg_data => l_msg_data,
1162: --

Line 1169: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1165: p_ccid => wal_rec.code_combination_id,
1166: p_budget_group_id => l_root_budget_group_id
1167: );
1168: -- If not able to decide status set the record to non updateable
1169: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1170: l_position_account_flag := 'Y';
1171: ELSE
1172: IF l_ccid_type = 'PERSONNEL_SERVICES' THEN
1173: l_position_account_flag := 'Y';

Line 1364: where nvl(c.pay_element_option_id, FND_API.G_MISS_NUM) = nvl(a.pay_element_option_id, FND_API.G_MISS_NUM)

1360: and a.element_value_type = 'PS'
1361: and exists
1362: (select 1
1363: from PSB_POSITION_ASSIGNMENTS c
1364: where nvl(c.pay_element_option_id, FND_API.G_MISS_NUM) = nvl(a.pay_element_option_id, FND_API.G_MISS_NUM)
1365: and (c.worksheet_id is null or c.worksheet_id = g_global_worksheet_id)
1366: and c.currency_code = g_currency_code
1367: and (((c.effective_start_date <= l_end_date)
1368: and (c.effective_end_date is null))

Line 1423: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

1419:
1420: g_num_poselem_rates := 0;
1421:
1422:
1423: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1424: raise FND_API.G_EXC_ERROR;
1425: end if;
1426:
1427: for c_Element_Assignments_Rec in c_Element_Assignments loop

Line 1424: raise FND_API.G_EXC_ERROR;

1420: g_num_poselem_rates := 0;
1421:
1422:
1423: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1424: raise FND_API.G_EXC_ERROR;
1425: end if;
1426:
1427: for c_Element_Assignments_Rec in c_Element_Assignments loop
1428:

Line 1458: p_return_status := FND_API.G_RET_STS_SUCCESS;

1454: g_poselem_rates(g_num_poselem_rates).formula_id := c_Element_Rates_Rec.formula_id;
1455:
1456: end loop;
1457:
1458: p_return_status := FND_API.G_RET_STS_SUCCESS;
1459: EXCEPTION
1460:
1461: when FND_API.G_EXC_ERROR then
1462: p_return_status := FND_API.G_RET_STS_ERROR;

Line 1461: when FND_API.G_EXC_ERROR then

1457:
1458: p_return_status := FND_API.G_RET_STS_SUCCESS;
1459: EXCEPTION
1460:
1461: when FND_API.G_EXC_ERROR then
1462: p_return_status := FND_API.G_RET_STS_ERROR;
1463:
1464: when FND_API.G_EXC_UNEXPECTED_ERROR then
1465: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1462: p_return_status := FND_API.G_RET_STS_ERROR;

1458: p_return_status := FND_API.G_RET_STS_SUCCESS;
1459: EXCEPTION
1460:
1461: when FND_API.G_EXC_ERROR then
1462: p_return_status := FND_API.G_RET_STS_ERROR;
1463:
1464: when FND_API.G_EXC_UNEXPECTED_ERROR then
1465: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1466:

Line 1464: when FND_API.G_EXC_UNEXPECTED_ERROR then

1460:
1461: when FND_API.G_EXC_ERROR then
1462: p_return_status := FND_API.G_RET_STS_ERROR;
1463:
1464: when FND_API.G_EXC_UNEXPECTED_ERROR then
1465: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1466:
1467: when OTHERS then
1468: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1465: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1461: when FND_API.G_EXC_ERROR then
1462: p_return_status := FND_API.G_RET_STS_ERROR;
1463:
1464: when FND_API.G_EXC_UNEXPECTED_ERROR then
1465: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1466:
1467: when OTHERS then
1468: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1469:

Line 1468: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1464: when FND_API.G_EXC_UNEXPECTED_ERROR then
1465: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1466:
1467: when OTHERS then
1468: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1469:
1470: END Cache_Position_Data;
1471:
1472:

Line 1539: l_ws_assignment := FND_API.G_FALSE;

1535: exit;
1536: end loop;
1537:
1538: -- Get the assignment data
1539: l_ws_assignment := FND_API.G_FALSE;
1540: for l_assign_index in 1..g_num_poselem_assignments loop
1541:
1542: if ((g_poselem_assignments(l_assign_index).pay_element_id = l_pay_element_id) and
1543: (g_poselem_assignments(l_assign_index).worksheet_id is not null) and

Line 1551: l_ws_assignment := FND_API.G_TRUE;

1547: (g_poselem_assignments(l_assign_index).end_date between l_budget_period_start_date and l_budget_period_end_date) or
1548: ((g_poselem_assignments(l_assign_index).start_date < l_budget_period_start_date) and
1549: (g_poselem_assignments(l_assign_index).end_date > l_budget_period_end_date))))) then
1550: begin
1551: l_ws_assignment := FND_API.G_TRUE;
1552: l_element_value := g_poselem_assignments(l_assign_index).element_value;
1553: l_pay_element_option_id := g_poselem_assignments(l_assign_index).pay_element_option_id;
1554: exit;
1555: end;

Line 1559: l_pos_assignment := FND_API.G_FALSE;

1555: end;
1556: end if;
1557: end loop;
1558:
1559: l_pos_assignment := FND_API.G_FALSE;
1560: if not FND_API.to_Boolean(l_ws_assignment) then
1561: begin
1562:
1563: for l_assign_index in 1..g_num_poselem_assignments loop

Line 1560: if not FND_API.to_Boolean(l_ws_assignment) then

1556: end if;
1557: end loop;
1558:
1559: l_pos_assignment := FND_API.G_FALSE;
1560: if not FND_API.to_Boolean(l_ws_assignment) then
1561: begin
1562:
1563: for l_assign_index in 1..g_num_poselem_assignments loop
1564:

Line 1575: l_pos_assignment := FND_API.G_TRUE;

1571: ((g_poselem_assignments(l_assign_index).start_date < l_budget_period_start_date) and
1572: (g_poselem_assignments(l_assign_index).end_date > l_budget_period_end_date))))) then
1573: begin
1574:
1575: l_pos_assignment := FND_API.G_TRUE;
1576: l_pay_element_option_id := g_poselem_assignments(l_assign_index).pay_element_option_id;
1577: l_element_value := g_poselem_assignments(l_assign_index).element_value;
1578: exit;
1579: end;

Line 1588: l_value_from_elem_rates := FND_API.G_FALSE;

1584: end;
1585: end if; -- if not ws assignment
1586:
1587: -- See if the value is arrived from element rates table
1588: l_value_from_elem_rates := FND_API.G_FALSE;
1589: if l_element_value is null then
1590:
1591: for l_rate_index in 1..g_num_poselem_rates loop
1592:

Line 1594: (nvl(g_poselem_rates(l_rate_index).pay_element_option_id, FND_API.G_MISS_NUM) = nvl(l_pay_element_option_id, FND_API.G_MISS_NUM)) and

1590:
1591: for l_rate_index in 1..g_num_poselem_rates loop
1592:
1593: if ((g_poselem_rates(l_rate_index).pay_element_id = l_pay_element_id) and
1594: (nvl(g_poselem_rates(l_rate_index).pay_element_option_id, FND_API.G_MISS_NUM) = nvl(l_pay_element_option_id, FND_API.G_MISS_NUM)) and
1595: (((g_poselem_rates(l_rate_index).start_date <= l_budget_period_end_date) and
1596: (g_poselem_rates(l_rate_index).end_date is null)) or
1597: ((g_poselem_rates(l_rate_index).start_date between l_budget_period_start_date and l_budget_period_end_date) or
1598: (g_poselem_rates(l_rate_index).end_date between l_budget_period_start_date and l_budget_period_end_date) or

Line 1601: l_value_from_elem_rates := FND_API.G_TRUE;

1597: ((g_poselem_rates(l_rate_index).start_date between l_budget_period_start_date and l_budget_period_end_date) or
1598: (g_poselem_rates(l_rate_index).end_date between l_budget_period_start_date and l_budget_period_end_date) or
1599: ((g_poselem_rates(l_rate_index).start_date < l_budget_period_start_date) and
1600: (g_poselem_rates(l_rate_index).end_date > l_budget_period_end_date))))) then
1601: l_value_from_elem_rates := FND_API.G_TRUE;
1602: l_element_value := g_poselem_rates(l_rate_index).element_value;
1603: exit;
1604: end if;
1605:

Line 1698: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

1694: PSB_WS_ACCT1.Cache_Budget_Calendar
1695: (p_return_status => l_return_status,
1696: p_budget_calendar_id => g_budget_calendar_id);
1697:
1698: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1699: raise FND_API.G_EXC_ERROR;
1700: end if;
1701:
1702: -- First set up the Positions view

Line 1699: raise FND_API.G_EXC_ERROR;

1695: (p_return_status => l_return_status,
1696: p_budget_calendar_id => g_budget_calendar_id);
1697:
1698: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1699: raise FND_API.G_EXC_ERROR;
1700: end if;
1701:
1702: -- First set up the Positions view
1703: psb_positions_i_pvt.initialize_view

Line 1809: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

1805: p_start_date => l_start_date,
1806: p_end_date => l_end_date);
1807:
1808:
1809: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1810: raise FND_API.G_EXC_ERROR;
1811: end if;
1812:
1813:

Line 1810: raise FND_API.G_EXC_ERROR;

1806: p_end_date => l_end_date);
1807:
1808:
1809: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1810: raise FND_API.G_EXC_ERROR;
1811: end if;
1812:
1813:
1814:

Line 1971: l_fte_rec_found := FND_API.G_FALSE;

1967: l_balance_type := g_ws_cols(col_index).balance_type;
1968: l_year_num_periods := g_year_num_periods(l_budget_year_id).num_of_periods;
1969: l_wlbi_end_index := l_wlbi_start_index + l_year_num_periods + 1;
1970:
1971: l_fte_rec_found := FND_API.G_FALSE;
1972: l_wal_rec_found := FND_API.G_FALSE;
1973:
1974: IF l_balance_type = 'F' THEN
1975: FOR fte_lines_rec IN

Line 1972: l_wal_rec_found := FND_API.G_FALSE;

1968: l_year_num_periods := g_year_num_periods(l_budget_year_id).num_of_periods;
1969: l_wlbi_end_index := l_wlbi_start_index + l_year_num_periods + 1;
1970:
1971: l_fte_rec_found := FND_API.G_FALSE;
1972: l_wal_rec_found := FND_API.G_FALSE;
1973:
1974: IF l_balance_type = 'F' THEN
1975: FOR fte_lines_rec IN
1976: (

Line 2000: l_fte_rec_found := FND_API.G_TRUE;

1996: or
1997: (g_stage_id between start_stage_seq and nvl(end_stage_seq, 9.99e125) ))
1998: )
1999: LOOP
2000: l_fte_rec_found := FND_API.G_TRUE;
2001: g_wlbi_amounts(l_wlbi_start_index).amount := fte_lines_rec.annual_fte;
2002: g_wal_period_amounts(1).amount := fte_lines_rec.period1_fte;
2003: g_wal_period_amounts(2).amount := fte_lines_rec.period2_fte;
2004: g_wal_period_amounts(3).amount := fte_lines_rec.period3_fte;

Line 2043: l_wal_rec_found := FND_API.G_TRUE;

2039: WHERE account_line_id = g_acl_ids(col_index).acl_id
2040: )
2041: LOOP
2042:
2043: l_wal_rec_found := FND_API.G_TRUE;
2044: g_wlbi_amounts(l_wlbi_start_index).amount := wal_rec.ytd_amount;
2045: l_start_stage_seq := wal_rec.start_stage_seq;
2046: l_current_stage_seq := wal_rec.current_stage_seq;
2047:

Line 2067: IF ( l_wal_rec_found = FND_API.G_TRUE ) OR

2063: -- Set the second column to zero percent for each year
2064: g_wlbi_amounts(l_wlbi_start_index+1).amount := 0; -- Set percentage to zero ; dummy column
2065:
2066: --
2067: IF ( l_wal_rec_found = FND_API.G_TRUE ) OR
2068: ( l_fte_rec_found = FND_API.G_TRUE ) THEN
2069: l_wal_col_index := 0;
2070: FOR l_wlbi_col_index in l_wlbi_start_index+2 .. l_wlbi_end_index
2071: LOOP

Line 2068: ( l_fte_rec_found = FND_API.G_TRUE ) THEN

2064: g_wlbi_amounts(l_wlbi_start_index+1).amount := 0; -- Set percentage to zero ; dummy column
2065:
2066: --
2067: IF ( l_wal_rec_found = FND_API.G_TRUE ) OR
2068: ( l_fte_rec_found = FND_API.G_TRUE ) THEN
2069: l_wal_col_index := 0;
2070: FOR l_wlbi_col_index in l_wlbi_start_index+2 .. l_wlbi_end_index
2071: LOOP
2072: l_wal_col_index := l_wal_col_index + 1;

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

3066:
3067: PROCEDURE Move_To_PSB
3068: (
3069: p_api_version IN NUMBER ,
3070: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
3071: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
3072: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
3073: p_return_status OUT NOCOPY VARCHAR2 ,
3074: p_msg_count OUT NOCOPY NUMBER ,

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

3067: PROCEDURE Move_To_PSB
3068: (
3069: p_api_version IN NUMBER ,
3070: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
3071: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
3072: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
3073: p_return_status OUT NOCOPY VARCHAR2 ,
3074: p_msg_count OUT NOCOPY NUMBER ,
3075: p_msg_data OUT NOCOPY VARCHAR2 ,

Line 3072: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

3068: (
3069: p_api_version IN NUMBER ,
3070: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
3071: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
3072: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
3073: p_return_status OUT NOCOPY VARCHAR2 ,
3074: p_msg_count OUT NOCOPY NUMBER ,
3075: p_msg_data OUT NOCOPY VARCHAR2 ,
3076: --

Line 3078: p_import_worksheet_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

3074: p_msg_count OUT NOCOPY NUMBER ,
3075: p_msg_data OUT NOCOPY VARCHAR2 ,
3076: --
3077: p_export_id IN NUMBER,
3078: p_import_worksheet_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
3079: p_amt_tolerance_value_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
3080: p_amt_tolerance_value IN NUMBER := FND_API.G_MISS_NUM,
3081: p_pct_tolerance_value_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
3082: p_pct_tolerance_value IN NUMBER := FND_API.G_MISS_NUM

Line 3079: p_amt_tolerance_value_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

3075: p_msg_data OUT NOCOPY VARCHAR2 ,
3076: --
3077: p_export_id IN NUMBER,
3078: p_import_worksheet_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
3079: p_amt_tolerance_value_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
3080: p_amt_tolerance_value IN NUMBER := FND_API.G_MISS_NUM,
3081: p_pct_tolerance_value_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
3082: p_pct_tolerance_value IN NUMBER := FND_API.G_MISS_NUM
3083: )

Line 3080: p_amt_tolerance_value IN NUMBER := FND_API.G_MISS_NUM,

3076: --
3077: p_export_id IN NUMBER,
3078: p_import_worksheet_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
3079: p_amt_tolerance_value_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
3080: p_amt_tolerance_value IN NUMBER := FND_API.G_MISS_NUM,
3081: p_pct_tolerance_value_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
3082: p_pct_tolerance_value IN NUMBER := FND_API.G_MISS_NUM
3083: )
3084: IS

Line 3081: p_pct_tolerance_value_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

3077: p_export_id IN NUMBER,
3078: p_import_worksheet_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
3079: p_amt_tolerance_value_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
3080: p_amt_tolerance_value IN NUMBER := FND_API.G_MISS_NUM,
3081: p_pct_tolerance_value_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
3082: p_pct_tolerance_value IN NUMBER := FND_API.G_MISS_NUM
3083: )
3084: IS
3085: BEGIN

Line 3082: p_pct_tolerance_value IN NUMBER := FND_API.G_MISS_NUM

3078: p_import_worksheet_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
3079: p_amt_tolerance_value_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
3080: p_amt_tolerance_value IN NUMBER := FND_API.G_MISS_NUM,
3081: p_pct_tolerance_value_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
3082: p_pct_tolerance_value IN NUMBER := FND_API.G_MISS_NUM
3083: )
3084: IS
3085: BEGIN
3086: g_msg_export_id := p_export_id;

Line 3123: p_stage_id IN NUMBER := FND_API.G_MISS_NUM ,

3119: retcode OUT NOCOPY VARCHAR2 ,
3120: --
3121: p_export_name IN VARCHAR2 ,
3122: p_worksheet_id IN NUMBER ,
3123: p_stage_id IN NUMBER := FND_API.G_MISS_NUM ,
3124: p_export_worksheet_type IN VARCHAR2
3125: )
3126: IS
3127: --

Line 3143: p_init_msg_list => FND_API.G_TRUE ,

3139: --
3140: PSB_Excel_Pvt.Move_To_Interface
3141: (
3142: p_api_version => 1.0 ,
3143: p_init_msg_list => FND_API.G_TRUE ,
3144: p_commit => FND_API.G_FALSE ,
3145: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
3146: p_return_status => l_return_status ,
3147: p_msg_count => l_msg_count ,

Line 3144: p_commit => FND_API.G_FALSE ,

3140: PSB_Excel_Pvt.Move_To_Interface
3141: (
3142: p_api_version => 1.0 ,
3143: p_init_msg_list => FND_API.G_TRUE ,
3144: p_commit => FND_API.G_FALSE ,
3145: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
3146: p_return_status => l_return_status ,
3147: p_msg_count => l_msg_count ,
3148: p_msg_data => l_msg_data ,

Line 3145: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,

3141: (
3142: p_api_version => 1.0 ,
3143: p_init_msg_list => FND_API.G_TRUE ,
3144: p_commit => FND_API.G_FALSE ,
3145: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
3146: p_return_status => l_return_status ,
3147: p_msg_count => l_msg_count ,
3148: p_msg_data => l_msg_data ,
3149: --

Line 3156: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3152: p_stage_id => p_stage_id ,
3153: p_export_worksheet_type => p_export_worksheet_type
3154: );
3155: --
3156: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3158: END IF ;
3159: --
3160: /* Start Bug No. 2322856 */

Line 3157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

3153: p_export_worksheet_type => p_export_worksheet_type
3154: );
3155: --
3156: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3158: END IF ;
3159: --
3160: /* Start Bug No. 2322856 */
3161: -- PSB_MESSAGE_S.Print_Success ;

Line 3169: WHEN FND_API.G_EXC_ERROR THEN

3165: COMMIT WORK;
3166: --
3167: EXCEPTION
3168: --
3169: WHEN FND_API.G_EXC_ERROR THEN
3170: --
3171: ROLLBACK TO Move_To_Inter_CP_Pvt ;
3172: --
3173: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,

Line 3174: p_print_header => FND_API.G_TRUE ) ;

3170: --
3171: ROLLBACK TO Move_To_Inter_CP_Pvt ;
3172: --
3173: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
3174: p_print_header => FND_API.G_TRUE ) ;
3175: retcode := 2 ;
3176: --
3177: Log_Messages(p_source_process => 'MOVE_TO_INTERFACE');
3178: COMMIT WORK ;

Line 3180: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3176: --
3177: Log_Messages(p_source_process => 'MOVE_TO_INTERFACE');
3178: COMMIT WORK ;
3179: --
3180: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3181: --
3182: ROLLBACK TO Move_To_Inter_CP_Pvt ;
3183: --
3184: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,

Line 3185: p_print_header => FND_API.G_TRUE ) ;

3181: --
3182: ROLLBACK TO Move_To_Inter_CP_Pvt ;
3183: --
3184: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
3185: p_print_header => FND_API.G_TRUE ) ;
3186: retcode := 2 ;
3187: --
3188: Log_Messages(p_source_process => 'MOVE_TO_INTERFACE');
3189: COMMIT WORK ;

Line 3202: p_print_header => FND_API.G_TRUE ) ;

3198: l_api_name ) ;
3199: END IF ;
3200: --
3201: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
3202: p_print_header => FND_API.G_TRUE ) ;
3203: retcode := 2 ;
3204: --
3205: Log_Messages(p_source_process => 'MOVE_TO_INTERFACE');
3206: COMMIT WORK ;

Line 3250: p_init_msg_list => FND_API.G_TRUE ,

3246: --
3247: PSB_Excel_Pvt.Move_TO_PSB
3248: (
3249: p_api_version => 1.0 ,
3250: p_init_msg_list => FND_API.G_TRUE ,
3251: p_commit => FND_API.G_FALSE ,
3252: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
3253: p_return_status => l_return_status ,
3254: p_msg_count => l_msg_count ,

Line 3251: p_commit => FND_API.G_FALSE ,

3247: PSB_Excel_Pvt.Move_TO_PSB
3248: (
3249: p_api_version => 1.0 ,
3250: p_init_msg_list => FND_API.G_TRUE ,
3251: p_commit => FND_API.G_FALSE ,
3252: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
3253: p_return_status => l_return_status ,
3254: p_msg_count => l_msg_count ,
3255: p_msg_data => l_msg_data ,

Line 3252: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,

3248: (
3249: p_api_version => 1.0 ,
3250: p_init_msg_list => FND_API.G_TRUE ,
3251: p_commit => FND_API.G_FALSE ,
3252: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
3253: p_return_status => l_return_status ,
3254: p_msg_count => l_msg_count ,
3255: p_msg_data => l_msg_data ,
3256: --

Line 3265: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3261: p_pct_tolerance_value_type => p_pct_tolerance_value_type ,
3262: p_pct_tolerance_value => p_pct_tolerance_value
3263: );
3264: --
3265: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3266: l_error_api_name := 'PSB_Excel_Pvt.Move_TO_PSB' ;
3267: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3268: END IF ;
3269: --

Line 3267: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

3263: );
3264: --
3265: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3266: l_error_api_name := 'PSB_Excel_Pvt.Move_TO_PSB' ;
3267: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3268: END IF ;
3269: --
3270: retcode := 0 ;
3271: PSB_MESSAGE_S.Get_Success_Message( p_msg_string => l_msg_data ) ;

Line 3278: WHEN FND_API.G_EXC_ERROR THEN

3274: COMMIT WORK;
3275: --
3276: EXCEPTION
3277: --
3278: WHEN FND_API.G_EXC_ERROR THEN
3279: --
3280: ROLLBACK TO Move_To_PSB_CP_Pvt ;
3281: --
3282: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,

Line 3283: p_print_header => FND_API.G_TRUE ) ;

3279: --
3280: ROLLBACK TO Move_To_PSB_CP_Pvt ;
3281: --
3282: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
3283: p_print_header => FND_API.G_TRUE ) ;
3284: retcode := 2 ;
3285: --
3286: Log_Messages(p_source_process => 'MOVE_TO_PSB');
3287: COMMIT WORK ;

Line 3289: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3285: --
3286: Log_Messages(p_source_process => 'MOVE_TO_PSB');
3287: COMMIT WORK ;
3288: --
3289: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3290: --
3291: ROLLBACK TO Move_To_PSB_CP_Pvt ;
3292: --
3293: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,

Line 3294: p_print_header => FND_API.G_TRUE ) ;

3290: --
3291: ROLLBACK TO Move_To_PSB_CP_Pvt ;
3292: --
3293: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
3294: p_print_header => FND_API.G_TRUE ) ;
3295: retcode := 2 ;
3296: --
3297: Log_Messages(p_source_process => 'MOVE_TO_PSB');
3298: COMMIT WORK ;

Line 3311: p_print_header => FND_API.G_TRUE ) ;

3307: l_api_name ) ;
3308: END IF ;
3309: --
3310: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
3311: p_print_header => FND_API.G_TRUE ) ;
3312: retcode := 2 ;
3313: --
3314: Log_Messages(p_source_process => 'MOVE_TO_PSB');
3315: COMMIT WORK ;

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

3328: --
3329: PROCEDURE Del_Worksheet
3330: (
3331: p_api_version IN NUMBER ,
3332: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
3333: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
3334: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
3335: p_return_status OUT NOCOPY VARCHAR2 ,
3336: p_msg_count OUT NOCOPY NUMBER ,

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

3329: PROCEDURE Del_Worksheet
3330: (
3331: p_api_version IN NUMBER ,
3332: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
3333: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
3334: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
3335: p_return_status OUT NOCOPY VARCHAR2 ,
3336: p_msg_count OUT NOCOPY NUMBER ,
3337: p_msg_data OUT NOCOPY VARCHAR2 ,

Line 3334: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

3330: (
3331: p_api_version IN NUMBER ,
3332: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
3333: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
3334: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
3335: p_return_status OUT NOCOPY VARCHAR2 ,
3336: p_msg_count OUT NOCOPY NUMBER ,
3337: p_msg_data OUT NOCOPY VARCHAR2 ,
3338: --

Line 3355: IF NOT FND_API.Compatible_API_Call ( l_api_version,

3351: --dbms_output.put_line('Exporting ...');
3352: --
3353: SAVEPOINT Del_Worksheet_Pvt ;
3354: --
3355: IF NOT FND_API.Compatible_API_Call ( l_api_version,
3356: p_api_version,
3357: l_api_name,
3358: G_PKG_NAME )
3359: THEN

Line 3360: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

3356: p_api_version,
3357: l_api_name,
3358: G_PKG_NAME )
3359: THEN
3360: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3361: END IF;
3362: --
3363:
3364: IF FND_API.To_Boolean ( p_init_msg_list ) THEN

Line 3364: IF FND_API.To_Boolean ( p_init_msg_list ) THEN

3360: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3361: END IF;
3362: --
3363:
3364: IF FND_API.To_Boolean ( p_init_msg_list ) THEN
3365: FND_MSG_PUB.initialize ;
3366: END IF;
3367: --
3368: p_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 3368: p_return_status := FND_API.G_RET_STS_SUCCESS ;

3364: IF FND_API.To_Boolean ( p_init_msg_list ) THEN
3365: FND_MSG_PUB.initialize ;
3366: END IF;
3367: --
3368: p_return_status := FND_API.G_RET_STS_SUCCESS ;
3369:
3370: DELETE FROM psb_ws_line_balances_i
3371: WHERE export_id = p_export_id;
3372:

Line 3379: IF FND_API.to_Boolean (p_commit) then

3375:
3376: DELETE FROM psb_worksheets_i
3377: WHERE export_id = p_export_id;
3378:
3379: IF FND_API.to_Boolean (p_commit) then
3380: commit work;
3381: END IF;
3382:
3383:

Line 3387: WHEN FND_API.G_EXC_ERROR THEN

3383:
3384: EXCEPTION
3385:
3386: --
3387: WHEN FND_API.G_EXC_ERROR THEN
3388:
3389: ROLLBACK TO Del_Worksheet_Pvt;
3390: p_return_status := FND_API.G_RET_STS_ERROR;
3391: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 3390: p_return_status := FND_API.G_RET_STS_ERROR;

3386: --
3387: WHEN FND_API.G_EXC_ERROR THEN
3388:
3389: ROLLBACK TO Del_Worksheet_Pvt;
3390: p_return_status := FND_API.G_RET_STS_ERROR;
3391: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
3392: p_data => p_msg_data );
3393: --
3394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3390: p_return_status := FND_API.G_RET_STS_ERROR;
3391: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
3392: p_data => p_msg_data );
3393: --
3394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3395:
3396: ROLLBACK TO Del_Worksheet_Pvt;
3397: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3398: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 3397: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3393: --
3394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3395:
3396: ROLLBACK TO Del_Worksheet_Pvt;
3397: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3398: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
3399: p_data => p_msg_data );
3400: --
3401: WHEN OTHERS THEN

Line 3403: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3399: p_data => p_msg_data );
3400: --
3401: WHEN OTHERS THEN
3402: ROLLBACK TO Del_Worksheet_Pvt;
3403: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3404: --
3405: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3406: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
3407: l_api_name);

Line 3450: p_init_msg_list => FND_API.G_TRUE ,

3446: --
3447: PSB_Excel_Pvt.Del_Worksheet
3448: (
3449: p_api_version => 1.0 ,
3450: p_init_msg_list => FND_API.G_TRUE ,
3451: p_commit => FND_API.G_FALSE ,
3452: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
3453: p_return_status => l_return_status ,
3454: p_msg_count => l_msg_count ,

Line 3451: p_commit => FND_API.G_FALSE ,

3447: PSB_Excel_Pvt.Del_Worksheet
3448: (
3449: p_api_version => 1.0 ,
3450: p_init_msg_list => FND_API.G_TRUE ,
3451: p_commit => FND_API.G_FALSE ,
3452: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
3453: p_return_status => l_return_status ,
3454: p_msg_count => l_msg_count ,
3455: p_msg_data => l_msg_data ,

Line 3452: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,

3448: (
3449: p_api_version => 1.0 ,
3450: p_init_msg_list => FND_API.G_TRUE ,
3451: p_commit => FND_API.G_FALSE ,
3452: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
3453: p_return_status => l_return_status ,
3454: p_msg_count => l_msg_count ,
3455: p_msg_data => l_msg_data ,
3456: --

Line 3460: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3456: --
3457: p_export_id => p_export_id
3458: );
3459: --
3460: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3461: l_error_api_name := 'PSB_Excel_Pvt.Del_Worksheet' ;
3462: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3463: END IF ;
3464: --

Line 3462: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

3458: );
3459: --
3460: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3461: l_error_api_name := 'PSB_Excel_Pvt.Del_Worksheet' ;
3462: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3463: END IF ;
3464: --
3465: retcode := 0 ;
3466: PSB_MESSAGE_S.Get_Success_Message( p_msg_string => l_msg_data ) ;

Line 3473: WHEN FND_API.G_EXC_ERROR THEN

3469: COMMIT WORK;
3470: --
3471: EXCEPTION
3472: --
3473: WHEN FND_API.G_EXC_ERROR THEN
3474: --
3475: ROLLBACK TO Del_Worksheet_CP_Pvt ;
3476: --
3477: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,

Line 3478: p_print_header => FND_API.G_TRUE ) ;

3474: --
3475: ROLLBACK TO Del_Worksheet_CP_Pvt ;
3476: --
3477: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
3478: p_print_header => FND_API.G_TRUE ) ;
3479: retcode := 2 ;
3480: --
3481: Log_Messages(p_source_process => 'DELETE_WORKSHEET');
3482: COMMIT WORK ;

Line 3484: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3480: --
3481: Log_Messages(p_source_process => 'DELETE_WORKSHEET');
3482: COMMIT WORK ;
3483: --
3484: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3485: --
3486: ROLLBACK TO Del_Worksheet_CP_Pvt ;
3487: --
3488: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,

Line 3489: p_print_header => FND_API.G_TRUE ) ;

3485: --
3486: ROLLBACK TO Del_Worksheet_CP_Pvt ;
3487: --
3488: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
3489: p_print_header => FND_API.G_TRUE ) ;
3490: retcode := 2 ;
3491: --
3492: Log_Messages(p_source_process => 'DELETE_WORKSHEET');
3493: COMMIT WORK ;

Line 3506: p_print_header => FND_API.G_TRUE ) ;

3502: l_api_name ) ;
3503: END IF ;
3504: --
3505: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
3506: p_print_header => FND_API.G_TRUE ) ;
3507: retcode := 2 ;
3508: --
3509: Log_Messages(p_source_process => 'DELETE_WORKSHEET');
3510: COMMIT WORK ;