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 836: p_init_msg_list => FND_API.G_FALSE,

832: IF (l_busdocs_tbl.COUNT >= 1) THEN
833:
834: okc_manage_deliverables_grp.updateIntContactOnDeliverables (
835: p_api_version => 1.0,
836: p_init_msg_list => FND_API.G_FALSE,
837: p_commit => FND_API.G_FALSE,
838: p_bus_docs_tbl => l_busdocs_tbl,
839: p_original_internal_contact_id => p_old_personid,
840: p_new_internal_contact_id => p_new_personid,

Line 837: p_commit => FND_API.G_FALSE,

833:
834: okc_manage_deliverables_grp.updateIntContactOnDeliverables (
835: p_api_version => 1.0,
836: p_init_msg_list => FND_API.G_FALSE,
837: p_commit => FND_API.G_FALSE,
838: p_bus_docs_tbl => l_busdocs_tbl,
839: p_original_internal_contact_id => p_old_personid,
840: p_new_internal_contact_id => p_new_personid,
841: x_msg_data => p_msg_data,

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

841: x_msg_data => p_msg_data,
842: x_msg_count => p_msg_count,
843: x_return_status => p_return_status);
844:
845: IF (p_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
846:
847: FND_MSG_PUB.Count_and_Get(p_count => p_msg_count,p_data => p_msg_data);
848: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
849:

Line 848: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

844:
845: IF (p_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
846:
847: FND_MSG_PUB.Count_and_Get(p_count => p_msg_count,p_data => p_msg_data);
848: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
849:
850: END IF;
851:
852: END IF;

Line 876: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

872: END IF;
873:
874: ROLLBACK TO Update_Buyer_REC_PO_SP;
875:
876: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
877:
878: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
879:
880: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );

Line 899: p_init_msg_list => FND_API.G_FALSE,

895: IF (l_busdocs_tbl.COUNT >= 1) THEN
896:
897: okc_manage_deliverables_grp.updateIntContactOnDeliverables (
898: p_api_version => 1.0,
899: p_init_msg_list => FND_API.G_FALSE,
900: p_commit => FND_API.G_FALSE,
901: p_bus_docs_tbl => l_busdocs_tbl,
902: p_original_internal_contact_id => p_old_personid,
903: p_new_internal_contact_id => p_new_personid,

Line 900: p_commit => FND_API.G_FALSE,

896:
897: okc_manage_deliverables_grp.updateIntContactOnDeliverables (
898: p_api_version => 1.0,
899: p_init_msg_list => FND_API.G_FALSE,
900: p_commit => FND_API.G_FALSE,
901: p_bus_docs_tbl => l_busdocs_tbl,
902: p_original_internal_contact_id => p_old_personid,
903: p_new_internal_contact_id => p_new_personid,
904: x_msg_data => p_msg_data,

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

904: x_msg_data => p_msg_data,
905: x_msg_count => p_msg_count,
906: x_return_status => p_return_status);
907:
908: IF (p_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
909:
910: FND_MSG_PUB.Count_and_Get(p_count => p_msg_count
911: ,p_data => p_msg_data);
912:

Line 913: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

909:
910: FND_MSG_PUB.Count_and_Get(p_count => p_msg_count
911: ,p_data => p_msg_data);
912:
913: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
914:
915: END IF;
916:
917: END IF;

Line 1204: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1200: END IF;
1201:
1202: ROLLBACK TO Update_Buyer_REC_REL_SP;
1203:
1204: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1205:
1206: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1207:
1208: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );

Line 1234: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1230: END IF;
1231:
1232: ROLLBACK TO PO_Mass_Update_Buyer_SP;
1233:
1234: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1235:
1236: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1237:
1238: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );

Line 1367: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1363: p_msg_data,
1364: p_msg_count,
1365: p_return_status);
1366:
1367: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1368: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1369: RETURN;
1370: END IF;
1371:

Line 1368: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1364: p_msg_count,
1365: p_return_status);
1366:
1367: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1368: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1369: RETURN;
1370: END IF;
1371:
1372:

Line 1431: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1427: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,l_log_head,l_progress|| SQLCODE || SUBSTR(SQLERRM,1,200));
1428:
1429: END IF;
1430:
1431: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1432:
1433: FND_MSG_PUB.Count_And_Get(
1434: p_count => p_msg_count,
1435: p_data => p_msg_data);

Line 1617: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1613: END IF;
1614:
1615: ROLLBACK TO Mass_Update_Forward_SP;
1616:
1617: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1618:
1619: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1620:
1621: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );

Line 1819: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1815: END IF;
1816:
1817: ROLLBACK TO Mass_Update_Forward_SP;
1818:
1819: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1820:
1821: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1822:
1823: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );

Line 1849: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1845: END IF;
1846:
1847: ROLLBACK TO PO_Mass_Update_Approver_SP;
1848:
1849: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1850:
1851: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1852:
1853: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );

Line 1981: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1977: p_msg_data,
1978: p_msg_count,
1979: p_return_status);
1980:
1981: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1982: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1983: RETURN;
1984: END IF;
1985:

Line 1982: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1978: p_msg_count,
1979: p_return_status);
1980:
1981: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1982: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1983: RETURN;
1984: END IF;
1985:
1986:

Line 2040: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2036: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,l_log_head,l_progress|| SQLCODE || SUBSTR(SQLERRM,1,200));
2037:
2038: END IF;
2039:
2040: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2041:
2042: FND_MSG_PUB.Count_And_Get(
2043: p_count => p_msg_count,
2044: p_data => p_msg_data);

Line 2234: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2230: END IF;
2231:
2232: ROLLBACK TO Update_DeliverTo_RECPO_SP;
2233:
2234: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2235:
2236: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2237:
2238: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );

Line 2439: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2435: END IF;
2436:
2437: ROLLBACK TO Update_DeliverTo_RECREL_SP;
2438:
2439: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2440:
2441: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2442:
2443: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );

Line 2469: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2465: END IF;
2466:
2467: ROLLBACK TO PO_Mass_Update_DeliverTo_SP;
2468:
2469: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2470:
2471: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2472:
2473: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );

Line 2679: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2675: END IF;
2676:
2677: ROLLBACK TO Print_SP;
2678:
2679: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2680:
2681: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2682:
2683: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );

Line 2912: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2908: END IF;
2909:
2910: ROLLBACK TO Buyer_Info_SP;
2911:
2912: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2913:
2914: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2915:
2916: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );