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 814: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

810: p_msg_data,
811: p_msg_count,
812: p_return_status);
813:
814: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
815: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
816: RETURN;
817: END IF;
818:

Line 815: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

811: p_msg_count,
812: p_return_status);
813:
814: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
815: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
816: RETURN;
817: END IF;
818:
819:

Line 879: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

875: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,l_log_head,l_progress || SQLCODE || SUBSTR(SQLERRM,1,200));
876:
877: END IF;
878:
879: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
880:
881: FND_MSG_PUB.Count_And_Get(
882: p_count => p_msg_count,
883: p_data => p_msg_data);

Line 1083: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1079: END IF;
1080:
1081: ROLLBACK TO Update_Req_Forward_SP;
1082:
1083: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1084:
1085: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1086:
1087: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );

Line 1114: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1110: END IF;
1111:
1112: ROLLBACK TO PO_Mass_Update_Approver_SP;
1113:
1114: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1115:
1116: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1117:
1118: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );

Line 1233: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1229: p_msg_data,
1230: p_msg_count,
1231: p_return_status);
1232:
1233: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1234: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1235: RETURN;
1236: END IF;
1237:

Line 1234: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1230: p_msg_count,
1231: p_return_status);
1232:
1233: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1234: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1235: RETURN;
1236: END IF;
1237:
1238:

Line 1291: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1287: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,l_log_head,l_progress || SQLCODE || SUBSTR(SQLERRM,1,200));
1288:
1289: END IF;
1290:
1291: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1292:
1293: FND_MSG_PUB.Count_And_Get(
1294: p_count => p_msg_count,
1295: p_data => p_msg_data);

Line 1492: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1488: END IF;
1489:
1490: ROLLBACK TO Update_Requestor_RECREQ_SP;
1491:
1492: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1493:
1494: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1495:
1496: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );

Line 1522: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1518: END IF;
1519:
1520: ROLLBACK TO PO_Mass_Update_Requestor_SP;
1521:
1522: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1523:
1524: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1525:
1526: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );

Line 1726: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1722: END IF;
1723:
1724: ROLLBACK TO Print_SP;
1725:
1726: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1727:
1728: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1729:
1730: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );

Line 1837: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1833: END IF;
1834:
1835: ROLLBACK TO Prep_Info_SP;
1836:
1837: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1838:
1839: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1840:
1841: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );