DBA Data[Home] [Help]

APPS.PO_MASS_UPDATE_PO_PVT dependencies on FND_API

Line 140: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

136: p_msg_data,
137: p_msg_count,
138: l_return_status);
139:
140: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
141: ROLLBACK TO PO_Mass_Update_Buyer_SP;
142: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
143: END IF;
144:

Line 142: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

138: l_return_status);
139:
140: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
141: ROLLBACK TO PO_Mass_Update_Buyer_SP;
142: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
143: END IF;
144:
145: END IF;
146:

Line 159: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

155: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,l_log_head,l_progress|| SQLCODE || SUBSTR(SQLERRM,1,200));
156:
157: END IF;
158:
159: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
160:
161: FND_MSG_PUB.Count_And_Get(
162: p_count => p_msg_count,
163: p_data => p_msg_data);

Line 198: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

194: p_msg_data,
195: p_msg_count,
196: l_return_status);
197:
198: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
199: ROLLBACK TO PO_Mass_Update_Approver_SP;
200: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
201: END IF;
202:

Line 200: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

196: l_return_status);
197:
198: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
199: ROLLBACK TO PO_Mass_Update_Approver_SP;
200: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
201: END IF;
202:
203:
204: EXCEPTION

Line 216: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

212: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,l_log_head,l_progress|| SQLCODE || SUBSTR(SQLERRM,1,200));
213:
214: END IF;
215:
216: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
217:
218: FND_MSG_PUB.Count_And_Get(
219: p_count => p_msg_count,
220: p_data => p_msg_data);

Line 255: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

251: p_msg_data,
252: p_msg_count,
253: l_return_status);
254:
255: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
256: ROLLBACK TO PO_Mass_Update_Deliver_To_SP;
257: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
258: END IF;
259:

Line 257: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

253: l_return_status);
254:
255: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
256: ROLLBACK TO PO_Mass_Update_Deliver_To_SP;
257: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
258: END IF;
259:
260:
261:

Line 275: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

271: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,l_log_head,l_progress|| SQLCODE || SUBSTR(SQLERRM,1,200));
272:
273: END IF;
274:
275: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
276:
277: FND_MSG_PUB.Count_And_Get(
278: p_count => p_msg_count,
279: p_data => p_msg_data);

Line 297: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

293: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,l_log_head,l_progress|| SQLCODE || SUBSTR(SQLERRM,1,200));
294:
295: END IF;
296:
297: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
298:
299: FND_MSG_PUB.Count_And_Get(
300: p_count => p_msg_count,
301: p_data => p_msg_data);

Line 448: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

444: p_msg_data,
445: p_msg_count,
446: p_return_status);
447:
448: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
449: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
450: RETURN;
451: END IF;
452:

Line 449: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

445: p_msg_count,
446: p_return_status);
447:
448: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
449: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
450: RETURN;
451: END IF;
452:
453:

Line 507: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

503: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,l_log_head,l_progress|| SQLCODE || SUBSTR(SQLERRM,1,200));
504:
505: END IF;
506:
507: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
508:
509: FND_MSG_PUB.Count_And_Get(
510: p_count => p_msg_count,
511: p_data => p_msg_data);

Line 781: p_init_msg_list => FND_API.G_FALSE,

777: IF (l_busdocs_tbl.COUNT >= 1) THEN
778:
779: okc_manage_deliverables_grp.updateIntContactOnDeliverables (
780: p_api_version => 1.0,
781: p_init_msg_list => FND_API.G_FALSE,
782: p_commit => FND_API.G_FALSE,
783: p_bus_docs_tbl => l_busdocs_tbl,
784: p_original_internal_contact_id => p_old_personid,
785: p_new_internal_contact_id => p_new_personid,

Line 782: p_commit => FND_API.G_FALSE,

778:
779: okc_manage_deliverables_grp.updateIntContactOnDeliverables (
780: p_api_version => 1.0,
781: p_init_msg_list => FND_API.G_FALSE,
782: p_commit => FND_API.G_FALSE,
783: p_bus_docs_tbl => l_busdocs_tbl,
784: p_original_internal_contact_id => p_old_personid,
785: p_new_internal_contact_id => p_new_personid,
786: x_msg_data => p_msg_data,

Line 790: IF (p_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

786: x_msg_data => p_msg_data,
787: x_msg_count => p_msg_count,
788: x_return_status => p_return_status);
789:
790: IF (p_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
791:
792: FND_MSG_PUB.Count_and_Get(p_count => p_msg_count,p_data => p_msg_data);
793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
794:

Line 793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

789:
790: IF (p_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
791:
792: FND_MSG_PUB.Count_and_Get(p_count => p_msg_count,p_data => p_msg_data);
793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
794:
795: END IF;
796:
797: END IF;

Line 821: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

817: END IF;
818:
819: ROLLBACK TO Update_Buyer_REC_PO_SP;
820:
821: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
822:
823: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
824:
825: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );

Line 844: p_init_msg_list => FND_API.G_FALSE,

840: IF (l_busdocs_tbl.COUNT >= 1) THEN
841:
842: okc_manage_deliverables_grp.updateIntContactOnDeliverables (
843: p_api_version => 1.0,
844: p_init_msg_list => FND_API.G_FALSE,
845: p_commit => FND_API.G_FALSE,
846: p_bus_docs_tbl => l_busdocs_tbl,
847: p_original_internal_contact_id => p_old_personid,
848: p_new_internal_contact_id => p_new_personid,

Line 845: p_commit => FND_API.G_FALSE,

841:
842: okc_manage_deliverables_grp.updateIntContactOnDeliverables (
843: p_api_version => 1.0,
844: p_init_msg_list => FND_API.G_FALSE,
845: p_commit => FND_API.G_FALSE,
846: p_bus_docs_tbl => l_busdocs_tbl,
847: p_original_internal_contact_id => p_old_personid,
848: p_new_internal_contact_id => p_new_personid,
849: x_msg_data => p_msg_data,

Line 853: IF (p_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

849: x_msg_data => p_msg_data,
850: x_msg_count => p_msg_count,
851: x_return_status => p_return_status);
852:
853: IF (p_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
854:
855: FND_MSG_PUB.Count_and_Get(p_count => p_msg_count
856: ,p_data => p_msg_data);
857:

Line 858: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

854:
855: FND_MSG_PUB.Count_and_Get(p_count => p_msg_count
856: ,p_data => p_msg_data);
857:
858: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
859:
860: END IF;
861:
862: END IF;

Line 1131: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1127: END IF;
1128:
1129: ROLLBACK TO Update_Buyer_REC_REL_SP;
1130:
1131: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1132:
1133: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1134:
1135: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );

Line 1161: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1157: END IF;
1158:
1159: ROLLBACK TO PO_Mass_Update_Buyer_SP;
1160:
1161: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1162:
1163: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1164:
1165: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );

Line 1294: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1290: p_msg_data,
1291: p_msg_count,
1292: p_return_status);
1293:
1294: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1295: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1296: RETURN;
1297: END IF;
1298:

Line 1295: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1291: p_msg_count,
1292: p_return_status);
1293:
1294: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1295: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1296: RETURN;
1297: END IF;
1298:
1299:

Line 1358: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1354: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,l_log_head,l_progress|| SQLCODE || SUBSTR(SQLERRM,1,200));
1355:
1356: END IF;
1357:
1358: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1359:
1360: FND_MSG_PUB.Count_And_Get(
1361: p_count => p_msg_count,
1362: p_data => p_msg_data);

Line 1544: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1540: END IF;
1541:
1542: ROLLBACK TO Mass_Update_Forward_SP;
1543:
1544: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1545:
1546: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1547:
1548: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );

Line 1746: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1742: END IF;
1743:
1744: ROLLBACK TO Mass_Update_Forward_SP;
1745:
1746: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1747:
1748: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1749:
1750: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );

Line 1776: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1772: END IF;
1773:
1774: ROLLBACK TO PO_Mass_Update_Approver_SP;
1775:
1776: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1777:
1778: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1779:
1780: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );

Line 1908: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1904: p_msg_data,
1905: p_msg_count,
1906: p_return_status);
1907:
1908: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1909: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1910: RETURN;
1911: END IF;
1912:

Line 1909: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1905: p_msg_count,
1906: p_return_status);
1907:
1908: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1909: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1910: RETURN;
1911: END IF;
1912:
1913:

Line 1967: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1963: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,l_log_head,l_progress|| SQLCODE || SUBSTR(SQLERRM,1,200));
1964:
1965: END IF;
1966:
1967: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1968:
1969: FND_MSG_PUB.Count_And_Get(
1970: p_count => p_msg_count,
1971: p_data => p_msg_data);

Line 2161: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2157: END IF;
2158:
2159: ROLLBACK TO Update_DeliverTo_RECPO_SP;
2160:
2161: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2162:
2163: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2164:
2165: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );

Line 2366: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2362: END IF;
2363:
2364: ROLLBACK TO Update_DeliverTo_RECREL_SP;
2365:
2366: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2367:
2368: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2369:
2370: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );

Line 2396: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2392: END IF;
2393:
2394: ROLLBACK TO PO_Mass_Update_DeliverTo_SP;
2395:
2396: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2397:
2398: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2399:
2400: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );

Line 2606: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2602: END IF;
2603:
2604: ROLLBACK TO Print_SP;
2605:
2606: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2607:
2608: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2609:
2610: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );

Line 2791: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2787: END IF;
2788:
2789: ROLLBACK TO Buyer_Info_SP;
2790:
2791: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2792:
2793: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2794:
2795: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );