APPS.CS_PARTYMERGE_PKG dependencies on FND_API

Line 397: x_return_status := FND_API.G_RET_STS_SUCCESS;

393: END IF;
394:
395: arp_message.set_line('CS_PARTYMERGE_PKG.UPDATE_CS_DATA()+');
396:
397: x_return_status := FND_API.G_RET_STS_SUCCESS;
398:
399: -- Update service request transaction data and create a SR audit record for each service request that is updated.
400: ----------------------------------------------------------------------------------------------------------------
401:

Line 582: IF l_return_status <> FND_API.G_RET_STS_ERROR Then

578: x_msg_count => x_msg_count,
579: x_msg_data => x_msg_data,
580: x_audit_vals_rec => l_audit_vals_rec);
581:
582: IF l_return_status <> FND_API.G_RET_STS_ERROR Then
583:
584: -- Populate the old values
585:
586: IF l_audit_vals_rec.customer_id <> l_customer_id_tbl(i) THEN

Line 678: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

674: p_creation_date => SYSDATE,
675: p_comments => NULL,
676: x_audit_id => l_audit_id);
677:
678: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
679: RAISE FND_API.G_EXC_ERROR;
680: END IF ;
681:
682: END LOOP; -- End loop for SR auditing

Line 679: RAISE FND_API.G_EXC_ERROR;

675: p_comments => NULL,
676: x_audit_id => l_audit_id);
677:
678: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
679: RAISE FND_API.G_EXC_ERROR;
680: END IF ;
681:
682: END LOOP; -- End loop for SR auditing
683:

Line 701: WHEN FND_API.G_EXC_ERROR THEN

697:
698: END LOOP; -- End lool for BULK SR processing in a batch of 1000
699: CLOSE C_Get_ServiceRequests;
700: EXCEPTION
701: WHEN FND_API.G_EXC_ERROR THEN
702: arp_message.set_line(g_pkg_name || '.' || g_proc_name || ': ' || sqlerrm);
703: x_return_status := FND_API.G_RET_STS_ERROR;
704: ROLLBACK;
705: RAISE;

Line 703: x_return_status := FND_API.G_RET_STS_ERROR;

699: CLOSE C_Get_ServiceRequests;
700: EXCEPTION
701: WHEN FND_API.G_EXC_ERROR THEN
702: arp_message.set_line(g_pkg_name || '.' || g_proc_name || ': ' || sqlerrm);
703: x_return_status := FND_API.G_RET_STS_ERROR;
704: ROLLBACK;
705: RAISE;
706:
707: WHEN resource_busy THEN

Line 710: x_return_status := FND_API.G_RET_STS_ERROR;

706:
707: WHEN resource_busy THEN
708: arp_message.set_line(g_pkg_name || '.' || g_proc_name || ': Could not obtain lock for records in table '||
709: 'CS_INCIDENTS_ALL_B for columns referring HZ parties');
710: x_return_status := FND_API.G_RET_STS_ERROR;
711: ROLLBACK;
712: RAISE;
713:
714: WHEN others THEN

Line 716: x_return_status := FND_API.G_RET_STS_ERROR;

712: RAISE;
713:
714: WHEN others THEN
715: arp_message.set_line(g_pkg_name || '.' || g_proc_name || ': ' || sqlerrm);
716: x_return_status := FND_API.G_RET_STS_ERROR;
717: ROLLBACK;
718: RAISE;
719: END ;
720:

Line 923: x_return_status := FND_API.G_RET_STS_ERROR;

919: EXCEPTION
920: WHEN resource_busy THEN
921: arp_message.set_line(g_pkg_name || '.' || g_proc_name || ': Could not obtain lock for records in table '||
922: 'CS_ESTIMATE_DETAILS for columns referring HZ entities');
923: x_return_status := FND_API.G_RET_STS_ERROR;
924: ROLLBACK;
925: RAISE;
926:
927: WHEN others THEN

Line 929: x_return_status := FND_API.G_RET_STS_ERROR;

925: RAISE;
926:
927: WHEN others THEN
928: arp_message.set_line(g_pkg_name || '.' || g_proc_name || ': ' || sqlerrm);
929: x_return_status := FND_API.G_RET_STS_ERROR;
930:
931: ROLLBACK;
932: RAISE;
933: END ;

Line 1159: x_return_status := FND_API.G_RET_STS_ERROR;

1155:
1156: EXCEPTION
1157: WHEN others THEN
1158: arp_message.set_line(g_pkg_name || '.' || g_proc_name || ': ' || sqlerrm);
1159: x_return_status := FND_API.G_RET_STS_ERROR;
1160: ROLLBACK;
1161: RAISE;
1162: END;
1163:

Line 1249: x_return_status := FND_API.G_RET_STS_ERROR;

1245: EXCEPTION
1246: WHEN others THEN
1247: arp_message.set_line(g_pkg_name || '.' || g_proc_name || ': ' || sqlerrm);
1248:
1249: x_return_status := FND_API.G_RET_STS_ERROR;
1250: ROLLBACK;
1251: RAISE;
1252: END ;
1253:

Line 1339: IF l_return_status = FND_API.G_RET_STS_SUCCESS Then

1335: , X_RETURN_STATUS => l_return_status
1336: , X_MSG_COUNT => x_msg_count
1337: , X_MSG_DATA => x_msg_data) ;
1338:
1339: IF l_return_status = FND_API.G_RET_STS_SUCCESS Then
1340:
1341: l_ext_attrs_tbl_old := l_ext_attrs_tbl_new ;
1342:
1343: -- Populate the old values

Line 1364: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1360: ,x_return_status => l_return_status
1361: ,x_msg_count => x_msg_count
1362: ,x_msg_data => x_msg_data);
1363:
1364: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1365: RAISE FND_API.G_EXC_ERROR;
1366: END IF ;
1367:
1368: END LOOP; -- End loop for SR auditing

Line 1365: RAISE FND_API.G_EXC_ERROR;

1361: ,x_msg_count => x_msg_count
1362: ,x_msg_data => x_msg_data);
1363:
1364: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1365: RAISE FND_API.G_EXC_ERROR;
1366: END IF ;
1367:
1368: END LOOP; -- End loop for SR auditing
1369:

Line 1392: x_return_status := FND_API.G_RET_STS_ERROR;

1388: EXCEPTION
1389: WHEN others THEN
1390: arp_message.set_line(g_pkg_name || '.' || g_proc_name || ': ' || sqlerrm);
1391:
1392: x_return_status := FND_API.G_RET_STS_ERROR;
1393: ROLLBACK;
1394: RAISE;
1395: END ;
1396:

Line 1427: x_return_status := FND_API.G_RET_STS_ERROR;

1423: EXCEPTION
1424: WHEN resource_busy THEN
1425: arp_message.set_line(g_pkg_name || '.' || g_proc_name || ': Could not obtain lock for records in table '||
1426: 'for columns referring HZ entities');
1427: x_return_status := FND_API.G_RET_STS_ERROR;
1428: ROLLBACK;
1429: RAISE;
1430:
1431: WHEN others THEN

Line 1433: x_return_status := FND_API.G_RET_STS_ERROR;

1429: RAISE;
1430:
1431: WHEN others THEN
1432: arp_message.set_line(g_pkg_name || '.' || g_proc_name || ': ' || sqlerrm);
1433: x_return_status := FND_API.G_RET_STS_ERROR;
1434: ROLLBACK;
1435: RAISE;
1436:
1437: END UPDATE_CS_DATA;