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_WS_OPS_PVT dependencies on FND_MSG_PUB

Line 107: FND_MSG_PUB.initialize ;

103: END IF;
104: --
105:
106: IF FND_API.To_Boolean ( p_init_msg_list ) THEN
107: FND_MSG_PUB.initialize ;
108: END IF;
109: --
110: p_return_status := FND_API.G_RET_STS_SUCCESS ;
111: --

Line 213: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

209: IF FND_API.To_Boolean ( p_commit ) THEN
210: COMMIT WORK;
211: END IF;
212: --
213: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
214: p_data => p_msg_data );
215: --
216: EXCEPTION
217: --

Line 223: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

219: --
220: -- For Bug 4337768: Commenting out Rollack.
221: -- ROLLBACK TO Enforce_WS_Concurrency_Pvt ;
222: p_return_status := FND_API.G_RET_STS_ERROR;
223: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
224: p_data => p_msg_data );
225: --
226: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
227: --

Line 230: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

226: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
227: --
228: ROLLBACK TO Enforce_WS_Concurrency_Pvt ;
229: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
230: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
231: p_data => p_msg_data );
232: --
233: WHEN OTHERS THEN
234: --

Line 238: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

234: --
235: ROLLBACK TO Enforce_WS_Concurrency_Pvt ;
236: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
237: --
238: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
239: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
240: l_api_name);
241: END if;
242: --

Line 239: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

235: ROLLBACK TO Enforce_WS_Concurrency_Pvt ;
236: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
237: --
238: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
239: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
240: l_api_name);
241: END if;
242: --
243: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 243: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

239: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
240: l_api_name);
241: END if;
242: --
243: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
244: p_data => p_msg_data );
245: --
246: END Enforce_WS_Concurrency ;
247: /*---------------------------------------------------------------------------*/

Line 293: FND_MSG_PUB.initialize ;

289: END IF;
290: --
291:
292: IF FND_API.To_Boolean ( p_init_msg_list ) THEN
293: FND_MSG_PUB.initialize ;
294: END IF;
295: --
296: p_return_status := FND_API.G_RET_STS_SUCCESS ;
297: --

Line 437: FND_MSG_PUB.Add;

433: ELSE
434: --
435: Fnd_Message.Set_Name ('PSB', 'PSB_INVALID_ARGUMENT') ;
436: Fnd_Message.Set_Token('ROUTINE', l_api_name ) ;
437: FND_MSG_PUB.Add;
438: RAISE FND_API.G_EXC_ERROR ;
439: --
440: END IF ;
441:

Line 447: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

443: IF FND_API.To_Boolean ( p_commit ) THEN
444: COMMIT WORK;
445: END IF;
446: --
447: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
448: p_data => p_msg_data );
449: --
450: EXCEPTION
451: --

Line 457: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

453: --
454: -- For Bug 4337768: Commenting out Rollback.
455: -- ROLLBACK TO Check_WS_Ops_Concurrency_Pvt ;
456: p_return_status := FND_API.G_RET_STS_ERROR;
457: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
458: p_data => p_msg_data );
459: --
460: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
461: --

Line 464: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

460: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
461: --
462: ROLLBACK TO Check_WS_Ops_Concurrency_Pvt ;
463: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
464: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
465: p_data => p_msg_data );
466: --
467: WHEN OTHERS THEN
468: --

Line 472: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

468: --
469: ROLLBACK TO Check_WS_Ops_Concurrency_Pvt ;
470: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
471: --
472: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
473: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
474: l_api_name );
475: END if;
476: --

Line 473: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

469: ROLLBACK TO Check_WS_Ops_Concurrency_Pvt ;
470: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
471: --
472: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
473: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
474: l_api_name );
475: END if;
476: --
477: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 477: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

473: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
474: l_api_name );
475: END if;
476: --
477: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
478: p_data => p_msg_data );
479: --
480: END Check_WS_Ops_Concurrency ;
481: /*---------------------------------------------------------------------------*/

Line 581: FND_MSG_PUB.initialize ;

577: END IF;
578: --
579:
580: IF FND_API.To_Boolean ( p_init_msg_list ) THEN
581: FND_MSG_PUB.initialize ;
582: END IF;
583: --
584: p_return_status := FND_API.G_RET_STS_SUCCESS ;
585: p_worksheet_id_OUT := 0 ;

Line 602: FND_MSG_PUB.Add;

598: IF p_account_position_set_tbl.COUNT = 0 THEN
599: --
600: Fnd_Message.Set_Name ('PSB', 'PSB_INVALID_ARGUMENT') ;
601: Fnd_Message.Set_Token('ROUTINE', l_api_name ) ;
602: FND_MSG_PUB.Add;
603: RAISE FND_API.G_EXC_ERROR ;
604: END IF ;
605:
606:

Line 618: FND_MSG_PUB.Add;

614: IF ( l_worksheets_csr%NOTFOUND ) THEN
615: --
616: Fnd_Message.Set_Name ('PSB', 'PSB_INVALID_WORKSHEET_ID') ;
617: Fnd_Message.Set_Token('ROUTINE', l_api_name ) ;
618: FND_MSG_PUB.Add;
619: RAISE FND_API.G_EXC_ERROR ;
620: END IF ;
621:
622: -- l_budget_by_position defines whether worksheet contains positions or not.

Line 982: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

978: IF FND_API.To_Boolean ( p_commit ) THEN
979: COMMIT WORK;
980: END IF;
981: --
982: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
983: p_data => p_msg_data );
984: --
985: EXCEPTION
986: --

Line 991: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

987: WHEN FND_API.G_EXC_ERROR THEN
988: --
989: ROLLBACK TO Create_Worksheet_Pvt ;
990: p_return_status := FND_API.G_RET_STS_ERROR;
991: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
992: p_data => p_msg_data );
993: --
994: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
995: --

Line 998: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

994: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
995: --
996: ROLLBACK TO Create_Worksheet_Pvt ;
997: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
998: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
999: p_data => p_msg_data );
1000: --
1001: WHEN OTHERS THEN
1002: --

Line 1014: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1010: --
1011: ROLLBACK TO Create_Worksheet_Pvt ;
1012: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1013: --
1014: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1015: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
1016: l_api_name);
1017: END if;
1018: --

Line 1015: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

1011: ROLLBACK TO Create_Worksheet_Pvt ;
1012: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1013: --
1014: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1015: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
1016: l_api_name);
1017: END if;
1018: --
1019: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 1019: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

1015: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
1016: l_api_name);
1017: END if;
1018: --
1019: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
1020: p_data => p_msg_data );
1021: --
1022: END Create_Worksheet;
1023: /*---------------------------------------------------------------------------*/

Line 1089: FND_MSG_PUB.initialize ;

1085: END IF;
1086: --
1087:
1088: IF FND_API.To_Boolean ( p_init_msg_list ) THEN
1089: FND_MSG_PUB.initialize ;
1090: END IF;
1091: --
1092: p_return_status := FND_API.G_RET_STS_SUCCESS ;
1093: --

Line 1113: FND_MSG_PUB.Add;

1109: IF ( l_worksheets_csr%NOTFOUND ) THEN
1110: --
1111: Fnd_Message.Set_Name ('PSB', 'PSB_INVALID_WORKSHEET_ID') ;
1112: Fnd_Message.Set_Token('ROUTINE', l_api_name ) ;
1113: FND_MSG_PUB.Add;
1114: RAISE FND_API.G_EXC_ERROR ;
1115: END IF ;
1116:
1117: -- l_budget_by_position defines whether worksheet contains positions or not.

Line 1400: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

1396: IF FND_API.To_Boolean ( p_commit ) THEN
1397: COMMIT WORK;
1398: END IF;
1399: --
1400: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
1401: p_data => p_msg_data );
1402: --
1403: EXCEPTION
1404: --

Line 1409: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

1405: WHEN FND_API.G_EXC_ERROR THEN
1406: --
1407: ROLLBACK TO Create_Worksheet_Pvt ;
1408: p_return_status := FND_API.G_RET_STS_ERROR;
1409: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
1410: p_data => p_msg_data );
1411: --
1412: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1413: --

Line 1416: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

1412: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1413: --
1414: ROLLBACK TO Create_Worksheet_Pvt ;
1415: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1416: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
1417: p_data => p_msg_data );
1418: --
1419: WHEN OTHERS THEN
1420: --

Line 1428: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1424: --
1425: ROLLBACK TO Create_Worksheet_Pvt ;
1426: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1427: --
1428: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1429: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
1430: l_api_name);
1431: END if;
1432: --

Line 1429: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

1425: ROLLBACK TO Create_Worksheet_Pvt ;
1426: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1427: --
1428: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1429: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
1430: l_api_name);
1431: END if;
1432: --
1433: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 1433: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

1429: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
1430: l_api_name);
1431: END if;
1432: --
1433: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
1434: p_data => p_msg_data );
1435: --
1436:
1437: END Create_Worksheet;

Line 1508: FND_MSG_PUB.initialize ;

1504: END IF;
1505: --
1506:
1507: IF FND_API.To_Boolean ( p_init_msg_list ) THEN
1508: FND_MSG_PUB.initialize ;
1509: END IF;
1510: --
1511: p_return_status := FND_API.G_RET_STS_SUCCESS ;
1512: --

Line 1525: FND_MSG_PUB.Add;

1521: IF ( l_worksheets_csr%NOTFOUND ) THEN
1522: --
1523: Fnd_Message.Set_Name ('PSB', 'PSB_INVALID_WORKSHEET_ID') ;
1524: Fnd_Message.Set_Token('ROUTINE', l_api_name ) ;
1525: FND_MSG_PUB.Add;
1526: RAISE FND_API.G_EXC_ERROR ;
1527: END IF ;
1528:
1529: -- l_budget_by_position defines whether worksheet contains positions or not.

Line 1537: FND_MSG_PUB.Add;

1533: -- Only official worksheet can be made copy of.
1534: --
1535: IF l_ws_row_type.worksheet_type <> 'O' THEN
1536: Fnd_Message.Set_Name ('PSB', 'PSB_INVALID_WORKSHEET_FOR_COPY') ;
1537: FND_MSG_PUB.Add;
1538: RAISE FND_API.G_EXC_ERROR ;
1539: END IF ;
1540:
1541: --

Line 1989: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

1985: IF FND_API.To_Boolean ( p_commit ) THEN
1986: COMMIT WORK;
1987: END IF;
1988: --
1989: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
1990: p_data => p_msg_data );
1991: --
1992: EXCEPTION
1993: --

Line 1998: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

1994: WHEN FND_API.G_EXC_ERROR THEN
1995: --
1996: ROLLBACK TO Copy_Worksheet_Pvt ;
1997: p_return_status := FND_API.G_RET_STS_ERROR;
1998: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
1999: p_data => p_msg_data );
2000: --
2001: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2002: --

Line 2005: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

2001: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2002: --
2003: ROLLBACK TO Copy_Worksheet_Pvt ;
2004: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2005: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
2006: p_data => p_msg_data );
2007: --
2008: WHEN OTHERS THEN
2009: --

Line 2017: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2013: --
2014: ROLLBACK TO Copy_Worksheet_Pvt ;
2015: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2016: --
2017: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2018: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
2019: l_api_name);
2020: END if;
2021: --

Line 2018: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

2014: ROLLBACK TO Copy_Worksheet_Pvt ;
2015: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2016: --
2017: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2018: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
2019: l_api_name);
2020: END if;
2021: --
2022: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 2022: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

2018: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
2019: l_api_name);
2020: END if;
2021: --
2022: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
2023: p_data => p_msg_data );
2024: --
2025: END Copy_Worksheet;
2026: /*---------------------------------------------------------------------------*/

Line 2124: FND_MSG_PUB.initialize ;

2120: END IF;
2121: --
2122:
2123: IF FND_API.To_Boolean ( p_init_msg_list ) THEN
2124: FND_MSG_PUB.initialize ;
2125: END IF;
2126: --
2127: p_return_status := FND_API.G_RET_STS_SUCCESS ;
2128: --

Line 2176: FND_MSG_PUB.Add;

2172: -- Check whether the p_target_worksheet_id has been frozen.
2173: --
2174: IF l_target_freeze_flag = 'Y' THEN
2175: Fnd_Message.Set_Name('PSB', 'PSB_TARGET_WORKSHEET_IS_FROZEN') ;
2176: FND_MSG_PUB.Add;
2177: RAISE FND_API.G_EXC_ERROR ;
2178: END IF ;
2179:
2180: --

Line 2192: FND_MSG_PUB.Add;

2188: AND (l_source_current_stage_seq = l_target_current_stage_seq )
2189: )
2190: THEN
2191: Fnd_Message.Set_Name ('PSB', 'PSB_INCOMPATIBLE_WORKSHEETS') ;
2192: FND_MSG_PUB.Add;
2193: RAISE FND_API.G_EXC_ERROR ;
2194: END IF ;
2195:
2196: --

Line 3253: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

3249: IF FND_API.To_Boolean ( p_commit ) THEN
3250: COMMIT WORK;
3251: END IF;
3252: --
3253: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
3254: p_data => p_msg_data );
3255: --
3256: EXCEPTION
3257: --

Line 3262: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

3258: WHEN FND_API.G_EXC_ERROR THEN
3259: --
3260: ROLLBACK TO Merge_Worksheets_Pvt ;
3261: p_return_status := FND_API.G_RET_STS_ERROR;
3262: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
3263: p_data => p_msg_data );
3264: --
3265: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3266: --

Line 3269: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

3265: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3266: --
3267: ROLLBACK TO Merge_Worksheets_Pvt ;
3268: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3269: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
3270: p_data => p_msg_data );
3271: --
3272: WHEN OTHERS THEN
3273: --

Line 3281: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3277: --
3278: ROLLBACK TO Merge_Worksheets_Pvt ;
3279: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3280: --
3281: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3282: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
3283: l_api_name);
3284: END if;
3285: --

Line 3282: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

3278: ROLLBACK TO Merge_Worksheets_Pvt ;
3279: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3280: --
3281: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3282: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
3283: l_api_name);
3284: END if;
3285: --
3286: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 3286: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

3282: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
3283: l_api_name);
3284: END if;
3285: --
3286: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
3287: p_data => p_msg_data );
3288: --
3289: END Merge_Worksheets;
3290: /*---------------------------------------------------------------------------*/

Line 3340: FND_MSG_PUB.initialize ;

3336: END IF;
3337: --
3338:
3339: IF FND_API.To_Boolean ( p_init_msg_list ) THEN
3340: FND_MSG_PUB.initialize ;
3341: END IF;
3342: --
3343: p_return_status := FND_API.G_RET_STS_SUCCESS ;
3344: --

Line 3680: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

3676: IF FND_API.To_Boolean ( p_commit ) THEN
3677: COMMIT WORK;
3678: END IF;
3679: --
3680: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
3681: p_data => p_msg_data );
3682: --
3683: EXCEPTION
3684: --

Line 3692: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

3688: --ROLLBACK TO Delete_Worksheet ;
3689: ROLLBACK;
3690: /*For Bug No : 2266309 End*/
3691: p_return_status := FND_API.G_RET_STS_ERROR;
3692: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
3693: p_data => p_msg_data );
3694: --
3695: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3696: --

Line 3702: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

3698: --ROLLBACK TO Delete_Worksheet ;
3699: ROLLBACK;
3700: /*For Bug No : 2266309 End*/
3701: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3702: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
3703: p_data => p_msg_data );
3704: --
3705: WHEN OTHERS THEN
3706: --

Line 3713: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3709: ROLLBACK;
3710: /*For Bug No : 2266309 End*/
3711: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3712: --
3713: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3714: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
3715: l_api_name);
3716: END if;
3717: --

Line 3714: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

3710: /*For Bug No : 2266309 End*/
3711: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3712: --
3713: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3714: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
3715: l_api_name);
3716: END if;
3717: --
3718: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 3718: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

3714: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
3715: l_api_name);
3716: END if;
3717: --
3718: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
3719: p_data => p_msg_data );
3720: --
3721: END Delete_Worksheet ;
3722: /*---------------------------------------------------------------------------*/

Line 3785: FND_MSG_PUB.initialize ;

3781: END IF;
3782: --
3783:
3784: IF FND_API.To_Boolean ( p_init_msg_list ) THEN
3785: FND_MSG_PUB.initialize ;
3786: END IF;
3787: --
3788: p_return_status := FND_API.G_RET_STS_SUCCESS ;
3789:

Line 3802: FND_MSG_PUB.Add;

3798: IF ( l_ws_lines_csr%NOTFOUND ) THEN
3799: --
3800: CLOSE l_ws_lines_csr ;
3801: Fnd_Message.Set_Name ('PSB', 'PSB_INVALID_ACCOUNT_LINE_ID') ;
3802: FND_MSG_PUB.Add;
3803: RAISE FND_API.G_EXC_ERROR ;
3804: END IF ;
3805:
3806: l_current_worksheet_id := p_worksheet_id ;

Line 3899: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

3895: IF FND_API.To_Boolean ( p_commit ) THEN
3896: COMMIT WORK;
3897: END IF;
3898: --
3899: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
3900: p_data => p_msg_data );
3901: --
3902: EXCEPTION
3903: --

Line 3908: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

3904: WHEN FND_API.G_EXC_ERROR THEN
3905: --
3906: ROLLBACK TO Add_Worksheet_Line_Pvt ;
3907: p_return_status := FND_API.G_RET_STS_ERROR;
3908: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
3909: p_data => p_msg_data );
3910: --
3911: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3912: --

Line 3915: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

3911: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3912: --
3913: ROLLBACK TO Add_Worksheet_Line_Pvt ;
3914: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3915: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
3916: p_data => p_msg_data );
3917: --
3918: WHEN OTHERS THEN
3919: --

Line 3927: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3923: --
3924: ROLLBACK TO Add_Worksheet_Line_Pvt ;
3925: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3926: --
3927: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3928: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
3929: l_api_name);
3930: END if;
3931: --

Line 3928: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

3924: ROLLBACK TO Add_Worksheet_Line_Pvt ;
3925: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3926: --
3927: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3928: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
3929: l_api_name);
3930: END if;
3931: --
3932: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 3932: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

3928: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
3929: l_api_name);
3930: END if;
3931: --
3932: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
3933: p_data => p_msg_data );
3934: --
3935: END Add_Worksheet_Line;
3936: /*---------------------------------------------------------------------------*/

Line 3989: FND_MSG_PUB.initialize;

3985: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3986: end if;
3987:
3988: if FND_API.To_Boolean (p_init_msg_list) then
3989: FND_MSG_PUB.initialize;
3990: end if;
3991:
3992: --
3993: -- Loop to find out all the account_line_id(s) which are associated with

Line 4032: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

4028: IF FND_API.To_Boolean (p_commit) THEN
4029: COMMIT WORK;
4030: END IF;
4031: --
4032: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
4033: p_data => p_msg_data );
4034: --
4035: p_return_status := FND_API.G_RET_STS_SUCCESS;
4036:

Line 4043: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

4039: WHEN FND_API.G_EXC_ERROR THEN
4040: --
4041: ROLLBACK TO Add_Worksheet_Line_Pvt ;
4042: p_return_status := FND_API.G_RET_STS_ERROR;
4043: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
4044: p_data => p_msg_data );
4045: --
4046: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4047: --

Line 4050: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

4046: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4047: --
4048: ROLLBACK TO Add_Worksheet_Line_Pvt ;
4049: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4050: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
4051: p_data => p_msg_data );
4052: --
4053: WHEN OTHERS THEN
4054: --

Line 4058: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

4054: --
4055: ROLLBACK TO Add_Worksheet_Line_Pvt ;
4056: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4057: --
4058: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4059: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
4060: l_api_name);
4061: END if;
4062: --

Line 4059: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

4055: ROLLBACK TO Add_Worksheet_Line_Pvt ;
4056: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4057: --
4058: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4059: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
4060: l_api_name);
4061: END if;
4062: --
4063: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 4063: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

4059: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
4060: l_api_name);
4061: END if;
4062: --
4063: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
4064: p_data => p_msg_data );
4065: --
4066: END Add_Worksheet_Line;
4067: /*---------------------------------------------------------------------------*/

Line 4122: FND_MSG_PUB.initialize ;

4118: END IF;
4119: --
4120:
4121: IF FND_API.To_Boolean ( p_init_msg_list ) THEN
4122: FND_MSG_PUB.initialize ;
4123: END IF;
4124: --
4125: p_return_status := FND_API.G_RET_STS_SUCCESS ;
4126:

Line 4135: FND_MSG_PUB.Add;

4131: IF ( l_ws_lines_csr%NOTFOUND ) THEN
4132: --
4133: CLOSE l_ws_lines_csr ;
4134: Fnd_Message.Set_Name ('PSB', 'PSB_INVALID_ACCOUNT_LINE_ID') ;
4135: FND_MSG_PUB.Add;
4136: RAISE FND_API.G_EXC_ERROR ;
4137: END IF ;
4138:
4139: -- Process all the worksheets in the table.

Line 4172: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

4168: IF FND_API.To_Boolean ( p_commit ) THEN
4169: COMMIT WORK;
4170: END IF;
4171: --
4172: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
4173: p_data => p_msg_data );
4174: --
4175: EXCEPTION
4176: --

Line 4181: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

4177: WHEN FND_API.G_EXC_ERROR THEN
4178: --
4179: ROLLBACK TO Add_Line_To_Worksheets_Pvt ;
4180: p_return_status := FND_API.G_RET_STS_ERROR;
4181: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
4182: p_data => p_msg_data );
4183: --
4184: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4185: --

Line 4188: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

4184: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4185: --
4186: ROLLBACK TO Add_Line_To_Worksheets_Pvt ;
4187: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4188: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
4189: p_data => p_msg_data );
4190: --
4191: WHEN OTHERS THEN
4192: --

Line 4196: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

4192: --
4193: ROLLBACK TO Add_Line_To_Worksheets_Pvt ;
4194: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4195: --
4196: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4197: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
4198: l_api_name);
4199: END if;
4200: --

Line 4197: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

4193: ROLLBACK TO Add_Line_To_Worksheets_Pvt ;
4194: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4195: --
4196: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4197: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
4198: l_api_name);
4199: END if;
4200: --
4201: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 4201: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

4197: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
4198: l_api_name);
4199: END if;
4200: --
4201: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
4202: p_data => p_msg_data );
4203: --
4204: END Add_Line_To_Worksheets ;
4205: /*---------------------------------------------------------------------------*/

Line 4269: FND_MSG_PUB.initialize ;

4265: END IF;
4266: --
4267:
4268: IF FND_API.To_Boolean ( p_init_msg_list ) THEN
4269: FND_MSG_PUB.initialize ;
4270: END IF;
4271: --
4272: p_return_status := FND_API.G_RET_STS_SUCCESS ;
4273:

Line 4286: FND_MSG_PUB.Add;

4282: IF ( l_ws_lines_positions_csr%NOTFOUND ) THEN
4283: --
4284: CLOSE l_ws_lines_positions_csr ;
4285: Fnd_Message.Set_Name ('PSB', 'PSB_INVALID_POSITION_LINE_ID') ;
4286: FND_MSG_PUB.Add;
4287: RAISE FND_API.G_EXC_ERROR ;
4288: END IF ;
4289:
4290: l_current_worksheet_id := p_worksheet_id ;

Line 4385: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

4381: IF FND_API.To_Boolean ( p_commit ) THEN
4382: COMMIT WORK;
4383: END IF;
4384: --
4385: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
4386: p_data => p_msg_data );
4387: --
4388: EXCEPTION
4389: --

Line 4394: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

4390: WHEN FND_API.G_EXC_ERROR THEN
4391: --
4392: ROLLBACK TO Add_Worksheet_Pos_Line_Pvt ;
4393: p_return_status := FND_API.G_RET_STS_ERROR;
4394: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
4395: p_data => p_msg_data );
4396: --
4397: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4398: --

Line 4401: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

4397: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4398: --
4399: ROLLBACK TO Add_Worksheet_Pos_Line_Pvt ;
4400: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4401: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
4402: p_data => p_msg_data );
4403: --
4404: WHEN OTHERS THEN
4405: --

Line 4413: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

4409: --
4410: ROLLBACK TO Add_Worksheet_Pos_Line_Pvt ;
4411: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4412: --
4413: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4414: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
4415: l_api_name);
4416: END if;
4417: --

Line 4414: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

4410: ROLLBACK TO Add_Worksheet_Pos_Line_Pvt ;
4411: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4412: --
4413: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4414: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
4415: l_api_name);
4416: END if;
4417: --
4418: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 4418: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

4414: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
4415: l_api_name);
4416: END if;
4417: --
4418: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
4419: p_data => p_msg_data );
4420: --
4421: END Add_Worksheet_Position_Line ;
4422: /*---------------------------------------------------------------------------*/

Line 4477: FND_MSG_PUB.initialize ;

4473: END IF;
4474: --
4475:
4476: IF FND_API.To_Boolean ( p_init_msg_list ) THEN
4477: FND_MSG_PUB.initialize ;
4478: END IF;
4479: --
4480: p_return_status := FND_API.G_RET_STS_SUCCESS ;
4481:

Line 4490: FND_MSG_PUB.Add;

4486: IF ( l_ws_lines_positions_csr%NOTFOUND ) THEN
4487: --
4488: CLOSE l_ws_lines_positions_csr ;
4489: Fnd_Message.Set_Name ('PSB', 'PSB_INVALID_POSITION_LINE_ID') ;
4490: FND_MSG_PUB.Add;
4491: RAISE FND_API.G_EXC_ERROR ;
4492: END IF ;
4493:
4494: -- Process all the worksheets in the table.

Line 4528: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

4524: IF FND_API.To_Boolean ( p_commit ) THEN
4525: COMMIT WORK;
4526: END IF;
4527: --
4528: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
4529: p_data => p_msg_data );
4530: --
4531: EXCEPTION
4532: --

Line 4537: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

4533: WHEN FND_API.G_EXC_ERROR THEN
4534: --
4535: ROLLBACK TO Add_Pos_Line_To_Worksheets_Pvt ;
4536: p_return_status := FND_API.G_RET_STS_ERROR;
4537: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
4538: p_data => p_msg_data );
4539: --
4540: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4541: --

Line 4544: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

4540: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4541: --
4542: ROLLBACK TO Add_Pos_Line_To_Worksheets_Pvt ;
4543: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4544: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
4545: p_data => p_msg_data );
4546: --
4547: WHEN OTHERS THEN
4548: --

Line 4552: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

4548: --
4549: ROLLBACK TO Add_Pos_Line_To_Worksheets_Pvt ;
4550: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4551: --
4552: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4553: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
4554: l_api_name);
4555: END if;
4556: --

Line 4553: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

4549: ROLLBACK TO Add_Pos_Line_To_Worksheets_Pvt ;
4550: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4551: --
4552: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4553: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
4554: l_api_name);
4555: END if;
4556: --
4557: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 4557: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

4553: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
4554: l_api_name);
4555: END if;
4556: --
4557: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
4558: p_data => p_msg_data );
4559: --
4560: END Add_Pos_Line_To_Worksheets ;
4561: /*---------------------------------------------------------------------------*/

Line 4617: FND_MSG_PUB.initialize ;

4613: END IF;
4614: --
4615:
4616: IF FND_API.To_Boolean ( p_init_msg_list ) THEN
4617: FND_MSG_PUB.initialize ;
4618: END IF;
4619: --
4620: p_return_status := FND_API.G_RET_STS_SUCCESS ;
4621: --

Line 4676: FND_MSG_PUB.Add;

4672:
4673: IF l_parent_freeze_flag = 'Y' THEN
4674:
4675: Fnd_Message.Set_Name('PSB','PSB_CANNOT_UNFREEZE_WORKSHEET') ;
4676: FND_MSG_PUB.Add;
4677: RAISE FND_API.G_EXC_ERROR ;
4678:
4679: END IF ;
4680:

Line 4755: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

4751: IF FND_API.To_Boolean ( p_commit ) THEN
4752: COMMIT WORK;
4753: END IF;
4754: --
4755: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
4756: p_data => p_msg_data );
4757: --
4758: EXCEPTION
4759: --

Line 4764: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

4760: WHEN FND_API.G_EXC_ERROR THEN
4761: --
4762: ROLLBACK TO Freeze_Worksheet_Pvt ;
4763: p_return_status := FND_API.G_RET_STS_ERROR;
4764: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
4765: p_data => p_msg_data );
4766: --
4767: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4768: --

Line 4771: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

4767: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4768: --
4769: ROLLBACK TO Freeze_Worksheet_Pvt ;
4770: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4771: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
4772: p_data => p_msg_data );
4773: --
4774: WHEN OTHERS THEN
4775: --

Line 4779: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

4775: --
4776: ROLLBACK TO Freeze_Worksheet_Pvt ;
4777: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4778: --
4779: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4780: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
4781: l_api_name);
4782: END if;
4783: --

Line 4780: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

4776: ROLLBACK TO Freeze_Worksheet_Pvt ;
4777: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4778: --
4779: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4780: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
4781: l_api_name);
4782: END if;
4783: --
4784: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 4784: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

4780: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
4781: l_api_name);
4782: END if;
4783: --
4784: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
4785: p_data => p_msg_data );
4786: --
4787: END Freeze_Worksheet ;
4788: /*---------------------------------------------------------------------------*/

Line 4846: FND_MSG_PUB.initialize ;

4842: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4843: END IF;
4844: --
4845: IF FND_API.To_Boolean ( p_init_msg_list ) THEN
4846: FND_MSG_PUB.initialize ;
4847: END IF;
4848: --
4849: p_return_status := FND_API.G_RET_STS_SUCCESS ;
4850: --

Line 5064: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

5060: IF FND_API.To_Boolean ( p_commit ) THEN
5061: COMMIT WORK;
5062: END IF;
5063: --
5064: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
5065: p_data => p_msg_data );
5066: --
5067: EXCEPTION
5068: --

Line 5073: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

5069: WHEN FND_API.G_EXC_ERROR THEN
5070: --
5071: ROLLBACK TO Change_Worksheet_Stage_Pvt ;
5072: p_return_status := FND_API.G_RET_STS_ERROR;
5073: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
5074: p_data => p_msg_data );
5075: --
5076: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5077: --

Line 5080: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

5076: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5077: --
5078: ROLLBACK TO Change_Worksheet_Stage_Pvt ;
5079: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5080: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
5081: p_data => p_msg_data );
5082: --
5083: WHEN OTHERS THEN
5084: --

Line 5088: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

5084: --
5085: ROLLBACK TO Change_Worksheet_Stage_Pvt ;
5086: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5087: --
5088: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5089: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
5090: l_api_name);
5091: END if;
5092: --

Line 5089: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

5085: ROLLBACK TO Change_Worksheet_Stage_Pvt ;
5086: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5087: --
5088: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5089: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
5090: l_api_name);
5091: END if;
5092: --
5093: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 5093: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

5089: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
5090: l_api_name);
5091: END if;
5092: --
5093: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
5094: p_data => p_msg_data );
5095: --
5096: END Change_Worksheet_Stage ;
5097: /*---------------------------------------------------------------------------*/

Line 5148: FND_MSG_PUB.initialize ;

5144: END IF;
5145: --
5146:
5147: IF FND_API.To_Boolean ( p_init_msg_list ) THEN
5148: FND_MSG_PUB.initialize ;
5149: END IF;
5150: --
5151: p_return_status := FND_API.G_RET_STS_SUCCESS ;
5152: p_worksheet_id_OUT := -99 ;

Line 5178: FND_MSG_PUB.Add;

5174: /* Commenting as this message is not required. The p_worksheet_id_OUT
5175: parameter should be used to determine whether parent worksheet exists.
5176:
5177: Fnd_Message.Set_Name('PSB','PSB_NO_PARENT_WORKSHEET' ) ;
5178: FND_MSG_PUB.Add;
5179: */
5180: p_worksheet_id_OUT := 0 ;
5181: RETURN ;
5182: END IF ;

Line 5244: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

5240: IF FND_API.To_Boolean ( p_commit ) THEN
5241: COMMIT WORK;
5242: END IF;
5243: --
5244: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
5245: p_data => p_msg_data );
5246: --
5247: EXCEPTION
5248: --

Line 5253: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

5249: WHEN FND_API.G_EXC_ERROR THEN
5250: --
5251: ROLLBACK TO Find_Parent_Worksheet_Pvt ;
5252: p_return_status := FND_API.G_RET_STS_ERROR;
5253: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
5254: p_data => p_msg_data );
5255: --
5256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5257: --

Line 5260: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

5256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5257: --
5258: ROLLBACK TO Find_Parent_Worksheet_Pvt ;
5259: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5260: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
5261: p_data => p_msg_data );
5262: --
5263: WHEN OTHERS THEN
5264: --

Line 5268: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

5264: --
5265: ROLLBACK TO Find_Parent_Worksheet_Pvt ;
5266: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5267: --
5268: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5269: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
5270: l_api_name);
5271: END if;
5272: --

Line 5269: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

5265: ROLLBACK TO Find_Parent_Worksheet_Pvt ;
5266: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5267: --
5268: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5269: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
5270: l_api_name);
5271: END if;
5272: --
5273: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 5273: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

5269: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
5270: l_api_name);
5271: END if;
5272: --
5273: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
5274: p_data => p_msg_data );
5275: --
5276: END Find_Parent_Worksheet ;
5277: /*---------------------------------------------------------------------------*/

Line 5326: FND_MSG_PUB.initialize ;

5322: END IF;
5323: --
5324:
5325: IF FND_API.To_Boolean ( p_init_msg_list ) THEN
5326: FND_MSG_PUB.initialize ;
5327: END IF;
5328: --
5329: p_return_status := FND_API.G_RET_STS_SUCCESS ;
5330: --

Line 5384: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

5380: IF FND_API.To_Boolean ( p_commit ) THEN
5381: COMMIT WORK;
5382: END IF;
5383: --
5384: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
5385: p_data => p_msg_data );
5386: --
5387: EXCEPTION
5388: --

Line 5393: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

5389: WHEN FND_API.G_EXC_ERROR THEN
5390: --
5391: ROLLBACK TO Find_Parent_Worksheets_Pvt ;
5392: p_return_status := FND_API.G_RET_STS_ERROR;
5393: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
5394: p_data => p_msg_data );
5395: --
5396: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5397: --

Line 5400: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

5396: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5397: --
5398: ROLLBACK TO Find_Parent_Worksheets_Pvt ;
5399: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5400: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
5401: p_data => p_msg_data );
5402: --
5403: WHEN OTHERS THEN
5404: --

Line 5408: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

5404: --
5405: ROLLBACK TO Find_Parent_Worksheets_Pvt ;
5406: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5407: --
5408: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5409: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
5410: l_api_name);
5411: END if;
5412: --

Line 5409: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

5405: ROLLBACK TO Find_Parent_Worksheets_Pvt ;
5406: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5407: --
5408: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5409: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
5410: l_api_name);
5411: END if;
5412: --
5413: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 5413: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

5409: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
5410: l_api_name);
5411: END if;
5412: --
5413: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
5414: p_data => p_msg_data );
5415: --
5416: END Find_Parent_Worksheets ;
5417: /*---------------------------------------------------------------------------*/

Line 5469: FND_MSG_PUB.initialize ;

5465: END IF;
5466: --
5467:
5468: IF FND_API.To_Boolean ( p_init_msg_list ) THEN
5469: FND_MSG_PUB.initialize ;
5470: END IF;
5471: --
5472: p_return_status := FND_API.G_RET_STS_SUCCESS ;
5473: --

Line 5604: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

5600: IF FND_API.To_Boolean ( p_commit ) THEN
5601: COMMIT WORK;
5602: END IF;
5603: --
5604: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
5605: p_data => p_msg_data );
5606: --
5607: EXCEPTION
5608: --

Line 5613: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

5609: WHEN FND_API.G_EXC_ERROR THEN
5610: --
5611: ROLLBACK TO Find_Child_Worksheets_Pvt ;
5612: p_return_status := FND_API.G_RET_STS_ERROR;
5613: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
5614: p_data => p_msg_data );
5615: --
5616: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5617: --

Line 5620: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

5616: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5617: --
5618: ROLLBACK TO Find_Child_Worksheets_Pvt ;
5619: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5620: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
5621: p_data => p_msg_data );
5622: --
5623: WHEN OTHERS THEN
5624: --

Line 5628: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

5624: --
5625: ROLLBACK TO Find_Child_Worksheets_Pvt ;
5626: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5627: --
5628: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5629: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
5630: l_api_name);
5631: END if;
5632: --

Line 5629: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

5625: ROLLBACK TO Find_Child_Worksheets_Pvt ;
5626: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5627: --
5628: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5629: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
5630: l_api_name);
5631: END if;
5632: --
5633: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 5633: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

5629: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
5630: l_api_name);
5631: END if;
5632: --
5633: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
5634: p_data => p_msg_data );
5635: --
5636: END Find_Child_Worksheets ;
5637: /*---------------------------------------------------------------------------*/

Line 5702: FND_MSG_PUB.initialize ;

5698: END IF;
5699: --
5700:
5701: IF FND_API.To_Boolean ( p_init_msg_list ) THEN
5702: FND_MSG_PUB.initialize ;
5703: END IF;
5704: --
5705: p_return_status := FND_API.G_RET_STS_SUCCESS ;
5706: --

Line 5790: FND_MSG_PUB.Add;

5786: AND ( l_source_global_worksheet_id = l_target_global_worksheet_id )
5787: )
5788: THEN
5789: Fnd_Message.Set_Name ('PSB', 'PSB_INCOMPATIBLE_WORKSHEETS') ;
5790: FND_MSG_PUB.Add;
5791: RAISE FND_API.G_EXC_ERROR ;
5792: END IF ;
5793:
5794: --

Line 5999: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

5995: IF FND_API.To_Boolean ( p_commit ) THEN
5996: COMMIT WORK;
5997: END IF;
5998: --
5999: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
6000: p_data => p_msg_data );
6001: --
6002: EXCEPTION
6003: --

Line 6008: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

6004: WHEN FND_API.G_EXC_ERROR THEN
6005: --
6006: ROLLBACK TO Update_Worksheet_Pvt ;
6007: p_return_status := FND_API.G_RET_STS_ERROR;
6008: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
6009: p_data => p_msg_data );
6010: --
6011: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6012: --

Line 6015: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

6011: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6012: --
6013: ROLLBACK TO Update_Worksheet_Pvt ;
6014: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6015: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
6016: p_data => p_msg_data );
6017: --
6018: WHEN OTHERS THEN
6019: --

Line 6024: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

6020: ROLLBACK TO Update_Worksheet_Pvt ;
6021: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6022: --
6023:
6024: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6025: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
6026: l_api_name);
6027: END if;
6028: --

Line 6025: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

6021: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6022: --
6023:
6024: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6025: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
6026: l_api_name);
6027: END if;
6028: --
6029: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 6029: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

6025: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
6026: l_api_name);
6027: END if;
6028: --
6029: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
6030: p_data => p_msg_data );
6031: --
6032: END Update_Worksheet ;
6033: /*---------------------------------------------------------------------------*/

Line 6197: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

6193: ROLLBACK TO Create_Local_Dist_Pvt ;
6194: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6195: --
6196: --
6197: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6198: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
6199: l_api_name );
6200: END IF;
6201: --

Line 6198: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

6194: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6195: --
6196: --
6197: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6198: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
6199: l_api_name );
6200: END IF;
6201: --
6202: END Create_Local_Dist_Pvt ;

Line 6276: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

6272: WHEN OTHERS THEN
6273: --
6274: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6275: --
6276: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6277: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
6278: l_api_name );
6279: END IF;
6280: --

Line 6277: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

6273: --
6274: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6275: --
6276: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6277: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
6278: l_api_name );
6279: END IF;
6280: --
6281: END Insert_WS_Lines_Pvt ;

Line 6506: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

6502: /*For Bug No : 2266309 End*/
6503: --
6504: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6505: --
6506: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6507: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
6508: l_api_name );
6509: END IF;
6510: --

Line 6507: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

6503: --
6504: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6505: --
6506: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6507: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
6508: l_api_name );
6509: END IF;
6510: --
6511: END Delete_Worksheet_Pvt ;

Line 6597: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

6593: /*For Bug No : 2266309 Start*/
6594: --ROLLBACK TO Delete_Worksheet_CP_Pvt ;
6595: ROLLBACK;
6596: /*For Bug No : 2266309 End*/
6597: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
6598: --
6599: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
6600: l_api_name ) ;
6601: END IF ;

Line 6599: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,

6595: ROLLBACK;
6596: /*For Bug No : 2266309 End*/
6597: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
6598: --
6599: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
6600: l_api_name ) ;
6601: END IF ;
6602: --
6603: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,

Line 6676: FND_MSG_PUB.initialize ;

6672: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
6673: END IF;
6674: --
6675: IF FND_API.To_Boolean ( p_init_msg_list ) THEN
6676: FND_MSG_PUB.initialize ;
6677: END IF;
6678: --
6679:
6680: p_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 6694: FND_MSG_PUB.Add;

6690: IF ( l_worksheets_rec.worksheet_Id IS NULL ) THEN
6691: --
6692: Fnd_Message.Set_Name ('PSB', 'PSB_INVALID_WORKSHEET_ID') ;
6693: Fnd_Message.Set_Token('ROUTINE', l_api_name ) ;
6694: FND_MSG_PUB.Add;
6695: RAISE FND_API.G_EXC_ERROR ;
6696: END IF ;
6697:
6698: -- l_budget_by_position defines whether worksheet contains positions or not.

Line 6947: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

6943: IF FND_API.To_Boolean ( p_commit ) THEN
6944: COMMIT WORK;
6945: END IF;
6946: --
6947: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
6948: p_data => p_msg_data );
6949: --
6950: EXCEPTION
6951: --

Line 6956: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

6952: WHEN FND_API.G_EXC_ERROR THEN
6953: --
6954: ROLLBACK TO Create_New_Position_WS_Pvt ;
6955: p_return_status := FND_API.G_RET_STS_ERROR;
6956: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
6957: p_data => p_msg_data );
6958: --
6959: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6960: --

Line 6963: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

6959: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6960: --
6961: ROLLBACK TO Create_New_Position_WS_Pvt ;
6962: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6963: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
6964: p_data => p_msg_data );
6965: --
6966: WHEN OTHERS THEN
6967: --

Line 6975: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

6971: --
6972: ROLLBACK TO Create_New_Position_WS_Pvt ;
6973: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6974: --
6975: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6976: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
6977: l_api_name);
6978: END if;
6979: --

Line 6976: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

6972: ROLLBACK TO Create_New_Position_WS_Pvt ;
6973: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6974: --
6975: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6976: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
6977: l_api_name);
6978: END if;
6979: --
6980: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 6980: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

6976: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
6977: l_api_name);
6978: END if;
6979: --
6980: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
6981: p_data => p_msg_data );
6982: --
6983: END Create_New_Position_Worksheet ;
6984: /*---------------------------------------------------------------------------*/