DBA Data[Home] [Help]

APPS.PO_MASS_UPDATE_REQ_PVT dependencies on FND_API

Line 113: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

109: p_msg_data,
110: p_msg_count,
111: l_return_status);
112:
113: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
114: ROLLBACK TO PO_Mass_Update_Preparer_SP;
115: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
116: END IF;
117:

Line 115: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

111: l_return_status);
112:
113: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
114: ROLLBACK TO PO_Mass_Update_Preparer_SP;
115: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
116: END IF;
117:
118: EXCEPTION
119:

Line 130: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

126: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,l_log_head,l_progress || SQLCODE || SUBSTR(SQLERRM,1,200));
127:
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);

Line 167: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

163: p_msg_data,
164: p_msg_count,
165: l_return_status);
166:
167: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
168: ROLLBACK TO PO_Mass_Update_Approver_SP;
169: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
170: END IF;
171:

Line 169: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

165: l_return_status);
166:
167: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
168: ROLLBACK TO PO_Mass_Update_Approver_SP;
169: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
170: END IF;
171:
172: EXCEPTION
173:

Line 184: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

180: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,l_log_head,l_progress || SQLCODE || SUBSTR(SQLERRM,1,200));
181:
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);

Line 221: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

217: p_msg_data,
218: p_msg_count,
219: l_return_status);
220:
221: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
222: ROLLBACK TO PO_Mass_Update_Requestor_SP;
223: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
224: END IF;
225:

Line 223: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

219: l_return_status);
220:
221: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
222: ROLLBACK TO PO_Mass_Update_Requestor_SP;
223: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
224: END IF;
225:
226:
227:

Line 240: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

236: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,l_log_head,l_progress || SQLCODE || SUBSTR(SQLERRM,1,200));
237:
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);

Line 262: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

258: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,l_log_head,l_progress || SQLCODE || SUBSTR(SQLERRM,1,200));
259:
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);

Line 384: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

380: p_msg_data,
381: p_msg_count,
382: p_return_status);
383:
384: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
385: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
386: RETURN;
387: END IF;
388:

Line 385: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

381: p_msg_count,
382: p_return_status);
383:
384: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
385: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
386: RETURN;
387: END IF;
388:
389:

Line 442: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

438: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,l_log_head,l_progress || SQLCODE || SUBSTR(SQLERRM,1,200));
439:
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);

Line 665: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

661: END IF;
662:
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 );

Line 693: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

689: END IF;
690:
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 );

Line 810: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

806: p_msg_data,
807: p_msg_count,
808: p_return_status);
809:
810: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
811: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
812: RETURN;
813: END IF;
814:

Line 811: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

807: p_msg_count,
808: p_return_status);
809:
810: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
811: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
812: RETURN;
813: END IF;
814:
815:

Line 875: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

871: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,l_log_head,l_progress || SQLCODE || SUBSTR(SQLERRM,1,200));
872:
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);

Line 1038: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1034: END IF;
1035:
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 );

Line 1069: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1065: END IF;
1066:
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 );

Line 1184: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1180: p_msg_data,
1181: p_msg_count,
1182: p_return_status);
1183:
1184: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1185: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1186: RETURN;
1187: END IF;
1188:

Line 1185: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1181: p_msg_count,
1182: p_return_status);
1183:
1184: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1185: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1186: RETURN;
1187: END IF;
1188:
1189:

Line 1242: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1238: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,l_log_head,l_progress || SQLCODE || SUBSTR(SQLERRM,1,200));
1239:
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);

Line 1410: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1406: END IF;
1407:
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 );

Line 1440: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1436: END IF;
1437:
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 );

Line 1644: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1640: END IF;
1641:
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 );

Line 1755: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1751: END IF;
1752:
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 );