[Home] [Help]
91: l_message VARCHAR2(4000);
92: l_ret_val BOOLEAN ;
93: pmt_trxn_rec get_transactions_details%ROWTYPE ;
94: BEGIN
95: -- Standard Start of API savepoint
96: SAVEPOINT validate_hold_processing;
97:
98: -- Standard call to check for call compatibility.
99: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
94: BEGIN
95: -- Standard Start of API savepoint
96: SAVEPOINT validate_hold_processing;
97:
98: -- Standard call to check for call compatibility.
99: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
100: THEN
101: RAISE fnd_api.g_exc_unexpected_error;
102: END IF;
531: l_waive_amount_total NUMBER;
532: l_waive_factor NUMBER;
533: BEGIN
534: --
535: -- Standard Start of API savepoint
536: --
537: SAVEPOINT update_pmt_transactions;
538:
539: --
536: --
537: SAVEPOINT update_pmt_transactions;
538:
539: --
540: -- Standard call to check for call compatibility.
541: --
542: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
543: THEN
544: RAISE fnd_api.g_exc_unexpected_error;
911: AND quota_id IS NULL;
912: END IF;
913:
914: -- End of API body.
915: -- Standard check of p_commit.
916: IF fnd_api.to_boolean (p_commit)
917: THEN
918: COMMIT WORK;
919: END IF;
917: THEN
918: COMMIT WORK;
919: END IF;
920:
921: -- Standard call to get message count and if count is 1, get message info.
922: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
923: EXCEPTION
924: WHEN fnd_api.g_exc_error
925: THEN
1007: AND status = 'UNPAID';
1008:
1009: BEGIN
1010: --
1011: -- Standard Start of API savepoint
1012: --
1013: SAVEPOINT create_pmt_transactions;
1014:
1015: --
1012: --
1013: SAVEPOINT create_pmt_transactions;
1014:
1015: --
1016: -- Standard call to check for call compatibility.
1017: --
1018: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
1019: THEN
1020: RAISE fnd_api.g_exc_unexpected_error;
1287: END IF;
1288: END IF;
1289:
1290: -- End of API body.
1291: -- Standard check of p_commit.
1292: IF fnd_api.to_boolean (p_commit)
1293: THEN
1294: COMMIT WORK;
1295: END IF;
1293: THEN
1294: COMMIT WORK;
1295: END IF;
1296:
1297: -- Standard call to get message count and if count is 1, get message info.
1298: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1299: EXCEPTION
1300: WHEN fnd_api.g_exc_error
1301: THEN
1366: --R12 for OA.
1367: l_validation_only VARCHAR2 (1);
1368: BEGIN
1369: --
1370: -- Standard Start of API savepoint
1371: --
1372: SAVEPOINT delete_pmt_transactions;
1373:
1374: --
1371: --
1372: SAVEPOINT delete_pmt_transactions;
1373:
1374: --
1375: -- Standard call to check for call compatibility.
1376: --
1377: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
1378: THEN
1379: RAISE fnd_api.g_exc_unexpected_error;
1475: AND (quota_id = trans_rec.quota_id OR quota_id IS NULL)
1476: ;
1477:
1478: -- End of API body.
1479: -- Standard check of p_commit.
1480: IF fnd_api.to_boolean (p_commit)
1481: THEN
1482: COMMIT WORK;
1483: END IF;
1481: THEN
1482: COMMIT WORK;
1483: END IF;
1484:
1485: -- Standard call to get message count and if count is 1, get message info.
1486: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1487: EXCEPTION
1488: WHEN fnd_api.g_exc_error
1489: THEN
1559: AND cpw.org_id = cp.org_id
1560: AND cpw.org_id = cpt.org_id;
1561: BEGIN
1562: --
1563: -- Standard Start of API savepoint
1564: --
1565: SAVEPOINT release_wksht_hold;
1566:
1567: --
1564: --
1565: SAVEPOINT release_wksht_hold;
1566:
1567: --
1568: -- Standard call to check for call compatibility.
1569: --
1570: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
1571: THEN
1572: RAISE fnd_api.g_exc_unexpected_error;
1610: );
1611: END LOOP;
1612:
1613: -- End of API body.
1614: -- Standard check of p_commit.
1615: IF fnd_api.to_boolean (p_commit)
1616: THEN
1617: COMMIT WORK;
1618: END IF;
1616: THEN
1617: COMMIT WORK;
1618: END IF;
1619:
1620: -- Standard call to get message count and if count is 1, get message info.
1621: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1622: EXCEPTION
1623: WHEN fnd_api.g_exc_error
1624: THEN
1887: l_msg_data VARCHAR2 (2000);
1888: l_msg_count NUMBER;
1889: l_status VARCHAR2(100) ;
1890: BEGIN
1891: -- Standard Start of API savepoint
1892: SAVEPOINT process_pmt_transactions;
1893:
1894: -- Standard call to check for call compatibility.
1895: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
1890: BEGIN
1891: -- Standard Start of API savepoint
1892: SAVEPOINT process_pmt_transactions;
1893:
1894: -- Standard call to check for call compatibility.
1895: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
1896: THEN
1897: RAISE fnd_api.g_exc_unexpected_error;
1898: END IF;