128: END IF;
129:
130: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
131:
132: FND_MSG_PUB.Count_And_Get(
133: p_count => p_msg_count,
134: p_data => p_msg_data);
135:
136: END;
182: END IF;
183:
184: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
185:
186: FND_MSG_PUB.Count_And_Get(
187: p_count => p_msg_count,
188: p_data => p_msg_data);
189:
190: END;
238: END IF;
239:
240: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
241:
242: FND_MSG_PUB.Count_And_Get(
243: p_count => p_msg_count,
244: p_data => p_msg_data);
245:
246: END;
260: END IF;
261:
262: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
263:
264: FND_MSG_PUB.Count_And_Get(
265: p_count => p_msg_count,
266: p_data => p_msg_data);
267:
268: END DO_Update;
440: END IF;
441:
442: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
443:
444: FND_MSG_PUB.Count_And_Get(
445: p_count => p_msg_count,
446: p_data => p_msg_data);
447:
448: END;
663: ROLLBACK TO Update_Preparer_RECREQ_SP;
664:
665: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
666:
667: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
668:
669: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );
670:
671: END IF;
665: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
666:
667: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
668:
669: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );
670:
671: END IF;
672:
673: END;
691: ROLLBACK TO PO_Mass_Update_Buyer_SP;
692:
693: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
694:
695: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
696:
697: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );
698:
699: END IF;
693: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
694:
695: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
696:
697: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );
698:
699: END IF;
700:
701: END Update_Preparer;
873: END IF;
874:
875: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
876:
877: FND_MSG_PUB.Count_And_Get(
878: p_count => p_msg_count,
879: p_data => p_msg_data);
880:
881: END;
1036: ROLLBACK TO Update_Req_Forward_SP;
1037:
1038: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1039:
1040: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1041:
1042: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );
1043:
1044: END IF;
1038: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1039:
1040: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1041:
1042: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );
1043:
1044: END IF;
1045:
1046: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => p_msg_count, p_data => p_msg_data );
1042: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );
1043:
1044: END IF;
1045:
1046: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => p_msg_count, p_data => p_msg_data );
1047:
1048: END;
1049:
1050:
1067: ROLLBACK TO PO_Mass_Update_Approver_SP;
1068:
1069: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1070:
1071: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1072:
1073: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );
1074:
1075: END IF;
1069: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1070:
1071: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1072:
1073: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );
1074:
1075: END IF;
1076:
1077: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => p_msg_count, p_data => p_msg_data );
1073: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );
1074:
1075: END IF;
1076:
1077: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => p_msg_count, p_data => p_msg_data );
1078:
1079: END Update_Approver;
1080:
1081: --------------------------------------------------------------------------------------------------
1240: END IF;
1241:
1242: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1243:
1244: FND_MSG_PUB.Count_And_Get(
1245: p_count => p_msg_count,
1246: p_data => p_msg_data);
1247:
1248: END;
1408: ROLLBACK TO Update_Requestor_RECREQ_SP;
1409:
1410: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1411:
1412: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1413:
1414: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );
1415:
1416: END IF;
1410: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1411:
1412: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1413:
1414: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );
1415:
1416: END IF;
1417:
1418: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => p_msg_count, p_data => p_msg_data );
1414: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );
1415:
1416: END IF;
1417:
1418: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => p_msg_count, p_data => p_msg_data );
1419:
1420: END;
1421:
1422: END LOOP;
1438: ROLLBACK TO PO_Mass_Update_Requestor_SP;
1439:
1440: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1441:
1442: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1443:
1444: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );
1445:
1446: END IF;
1440: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1441:
1442: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1443:
1444: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );
1445:
1446: END IF;
1447:
1448: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => p_msg_count, p_data => p_msg_data );
1444: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );
1445:
1446: END IF;
1447:
1448: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => p_msg_count, p_data => p_msg_data );
1449:
1450: END Update_Requestor;
1451:
1452: --------------------------------------------------------------------------------------------------
1642: ROLLBACK TO Print_SP;
1643:
1644: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1645:
1646: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1647:
1648: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );
1649:
1650: END IF;
1644: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1645:
1646: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1647:
1648: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );
1649:
1650: END IF;
1651:
1652: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => p_msg_count, p_data => p_msg_data );
1648: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );
1649:
1650: END IF;
1651:
1652: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => p_msg_count, p_data => p_msg_data );
1653:
1654: END Print_Output;
1655:
1656: --------------------------------------------------------------------------------------------------
1753: ROLLBACK TO Prep_Info_SP;
1754:
1755: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1756:
1757: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1758:
1759: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );
1760:
1761: END IF;
1755: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1756:
1757: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1758:
1759: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );
1760:
1761: END IF;
1762:
1763: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => p_msg_count, p_data => p_msg_data );
1759: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );
1760:
1761: END IF;
1762:
1763: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => p_msg_count, p_data => p_msg_data );
1764:
1765: END Preparer_Info;
1766:
1767: --------------------------------------------------------------------------------------------------