132: l_encumbrance_flag VARCHAR2(1);
133: l_ussgl_option VARCHAR2(1);
134:
135: BEGIN
136: -- Standard start of API savepoint
137: SAVEPOINT Seed_RAEEvent_PVT;
138:
139: l_stmt_num := 0;
140:
142: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,G_LOG_HEAD || '.'||l_api_name||'.begin'
143: ,'Seed_RAEEvent <<');
144: END IF;
145:
146: -- Standard call to check for call compatibility
147: IF NOT FND_API.Compatible_API_Call (
148: l_api_version,
149: p_api_version,
150: l_api_name,
629:
630:
631: x_rcv_event := l_rcv_event;
632:
633: --- Standard check of p_commit
634: IF FND_API.to_Boolean(p_commit) THEN
635: COMMIT WORK;
636: END IF;
637:
634: IF FND_API.to_Boolean(p_commit) THEN
635: COMMIT WORK;
636: END IF;
637:
638: -- Standard Call to get message count and if count = 1, get message info
639: FND_MSG_PUB.Count_And_Get (
640: p_count => x_msg_count,
641: p_data => x_msg_data );
642:
741: l_parent_txn_id NUMBER;
742: l_par_rcv_txn_type RCV_Transactions.transaction_type%TYPE;
743:
744: BEGIN
745: -- Standard start of API savepoint
746: SAVEPOINT Get_TransactionAmount_PVT;
747:
748: l_stmt_num := 0;
749:
751: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,G_LOG_HEAD || '.'||l_api_name||'.begin'
752: ,'Get_TransactionAmount <<');
753: END IF;
754:
755: -- Standard call to check for call compatibility
756: IF NOT FND_API.Compatible_API_Call (
757: l_api_version,
758: p_api_version,
759: l_api_name,
881: END IF;
882:
883:
884:
885: --- Standard check of p_commit
886: IF FND_API.to_Boolean(p_commit) THEN
887: COMMIT WORK;
888: END IF;
889:
886: IF FND_API.to_Boolean(p_commit) THEN
887: COMMIT WORK;
888: END IF;
889:
890: -- Standard Call to get message count and if count = 1, get message info
891: FND_MSG_PUB.Count_And_Get (
892: p_count => x_msg_count,
893: p_data => x_msg_data );
894:
997: l_par_rcv_txn_type RCV_Transactions.transaction_type%TYPE;
998:
999:
1000: BEGIN
1001: -- Standard start of API savepoint
1002: SAVEPOINT Get_Quantity_PVT;
1003:
1004: l_stmt_num := 0;
1005:
1008: ,'Get_Quantity <<');
1009: END IF;
1010:
1011:
1012: -- Standard call to check for call compatibility
1013: IF NOT FND_API.Compatible_API_Call (
1014: l_api_version,
1015: p_api_version,
1016: l_api_name,
1154: ,l_api_message);
1155: END IF;
1156:
1157:
1158: --- Standard check of p_commit
1159: IF FND_API.to_Boolean(p_commit) THEN
1160: COMMIT WORK;
1161: END IF;
1162:
1159: IF FND_API.to_Boolean(p_commit) THEN
1160: COMMIT WORK;
1161: END IF;
1162:
1163: -- Standard Call to get message count and if count = 1, get message info
1164: FND_MSG_PUB.Count_And_Get (
1165: p_count => x_msg_count,
1166: p_data => x_msg_data );
1167:
1285: l_incr_currency_code RCV_ACCOUNTING_EVENTS.CURRENCY_CODE%TYPE;
1286: l_incr_transfer_price NUMBER;
1287:
1288: BEGIN
1289: -- Standard start of API savepoint
1290: SAVEPOINT Get_UnitPrice_PVT;
1291:
1292: l_stmt_num := 0;
1293:
1295: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,G_LOG_HEAD || '.'||l_api_name||'.begin'
1296: ,'Get_UnitPrice <<');
1297: END IF;
1298:
1299: -- Standard call to check for call compatibility
1300: IF NOT FND_API.Compatible_API_Call (
1301: l_api_version,
1302: p_api_version,
1303: l_api_name,
1516: END IF;
1517:
1518:
1519:
1520: -- Standard check of p_commit
1521: IF FND_API.to_Boolean(p_commit) THEN
1522: COMMIT WORK;
1523: END IF;
1524:
1521: IF FND_API.to_Boolean(p_commit) THEN
1522: COMMIT WORK;
1523: END IF;
1524:
1525: -- Standard Call to get message count and if count = 1, get message info
1526: FND_MSG_PUB.Count_And_Get (
1527: p_count => x_msg_count,
1528: p_data => x_msg_data );
1529:
1641: l_err_code VARCHAR2(240);
1642: l_err_msg VARCHAR2(240);
1643:
1644: BEGIN
1645: -- Standard start of API savepoint
1646: SAVEPOINT Get_UnitTax_PVT;
1647:
1648: l_stmt_num := 0;
1649: l_hook_used:= 0;
1652: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,G_LOG_HEAD || '.'||l_api_name||'.begin'
1653: ,'Get_UnitTax <<');
1654: END IF;
1655:
1656: -- Standard call to check for call compatibility
1657: IF NOT FND_API.Compatible_API_Call (
1658: l_api_version,
1659: p_api_version,
1660: l_api_name,
1807: ,l_api_message);
1808: END IF;
1809:
1810:
1811: --- Standard check of p_commit
1812: IF FND_API.to_Boolean(p_commit) THEN
1813: COMMIT WORK;
1814: END IF;
1815:
1812: IF FND_API.to_Boolean(p_commit) THEN
1813: COMMIT WORK;
1814: END IF;
1815:
1816: -- Standard Call to get message count and if count = 1, get message info
1817: FND_MSG_PUB.Count_And_Get (
1818: p_count => x_msg_count,
1819: p_data => x_msg_data );
1820:
1940: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,G_LOG_HEAD ||l_api_name||'.begin'
1941: ,'Convert_UOM <<');
1942: END IF;
1943:
1944: -- Standard check for compatibility
1945: IF NOT FND_API.Compatible_API_Call (
1946: l_api_version,
1947: P_API_VERSION,
1948: l_api_name,
2054: END IF;
2055:
2056: -- End of API body
2057:
2058: -- Standard check of P_COMMIT
2059: IF FND_API.to_Boolean(P_COMMIT) THEN
2060: COMMIT WORK;
2061: END IF;
2062:
2202: BEGIN
2203:
2204: SAVEPOINT Get_Currency_PVT;
2205:
2206: -- Standard call to check for call compatibility
2207: IF NOT FND_API.Compatible_API_Call (
2208: l_api_version,
2209: p_api_version,
2210: l_api_name,
2318: p_count => X_MSG_COUNT,
2319: p_data => X_MSG_DATA );
2320:
2321:
2322: -- Standard check of P_COMMIT
2323: IF FND_API.to_Boolean(P_COMMIT) THEN
2324: COMMIT WORK;
2325: END IF;
2326:
2470: l_parent_trx_type rcv_transactions.transaction_type%TYPE;
2471: l_parent_trx_id NUMBER;
2472: l_account_flag NUMBER := 0;
2473: BEGIN
2474: -- Standard start of API savepoint
2475: SAVEPOINT Get_Accounts_PVT;
2476:
2477: l_stmt_num := 0;
2478:
2481: ,'Get_Accounts <<');
2482:
2483: END IF;
2484:
2485: -- Standard call to check for call compatibility
2486: IF NOT FND_API.Compatible_API_Call (
2487: l_api_version,
2488: p_api_version,
2489: l_api_name,
2888: RAISE FND_API.g_exc_error;
2889: END IF;
2890:
2891:
2892: -- Standard check of p_commit
2893: IF FND_API.to_Boolean(p_commit) THEN
2894: COMMIT WORK;
2895: END IF;
2896:
2893: IF FND_API.to_Boolean(p_commit) THEN
2894: COMMIT WORK;
2895: END IF;
2896:
2897: -- Standard Call to get message count and if count = 1, get message info
2898: FND_MSG_PUB.Count_And_Get (
2899: p_count => x_msg_count,
2900: p_data => x_msg_data );
2901:
3000: l_dist_acct_id NUMBER;
3001: l_account_flag NUMBER;
3002:
3003: BEGIN
3004: -- Standard start of API savepoint
3005: SAVEPOINT Get_HookAccount_PVT;
3006:
3007: l_stmt_num := 0;
3008:
3011: ,'Get_HookAccount <<');
3012:
3013: END IF;
3014:
3015: -- Standard call to check for call compatibility
3016: IF NOT FND_API.Compatible_API_Call (
3017: l_api_version,
3018: p_api_version,
3019: l_api_name,
3077: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
3078: ,l_api_message);
3079: END IF;
3080:
3081: -- Standard check of p_commit
3082: IF FND_API.to_Boolean(p_commit) THEN
3083: COMMIT WORK;
3084: END IF;
3085:
3082: IF FND_API.to_Boolean(p_commit) THEN
3083: COMMIT WORK;
3084: END IF;
3085:
3086: -- Standard Call to get message count and if count = 1, get message info
3087: FND_MSG_PUB.Count_And_Get (
3088: p_count => x_msg_count,
3089: p_data => x_msg_data );
3090:
3199:
3200: l_ctr_first NUMBER;
3201:
3202: BEGIN
3203: -- Standard start of API savepoint
3204: SAVEPOINT Insert_RAEEvents_PVT;
3205:
3206: l_stmt_num := 0;
3207:
3210: ,'Insert_RAEEvents <<');
3211:
3212: END IF;
3213:
3214: -- Standard call to check for call compatibility
3215: IF NOT FND_API.Compatible_API_Call (
3216: l_api_version,
3217: p_api_version,
3218: l_api_name,
3496: END LOOP;
3497:
3498:
3499:
3500: --- Standard check of p_commit
3501: IF FND_API.to_Boolean(p_commit) THEN
3502: COMMIT WORK;
3503: END IF;
3504:
3501: IF FND_API.to_Boolean(p_commit) THEN
3502: COMMIT WORK;
3503: END IF;
3504:
3505: -- Standard Call to get message count and if count = 1, get message info
3506: FND_MSG_PUB.Count_And_Get (
3507: p_count => x_msg_count,
3508: p_data => x_msg_data );
3509:
3610:
3611: l_encumbrance_flag VARCHAR2(1);
3612:
3613: BEGIN
3614: -- Standard start of API savepoint
3615: SAVEPOINT Check_EncumbranceFlag_PVT;
3616:
3617: l_stmt_num := 0;
3618:
3620: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,G_LOG_HEAD || '.'||l_api_name||'.begin'
3621: ,'Check_EncumbranceFlag <<');
3622: END IF;
3623:
3624: -- Standard call to check for call compatibility
3625: IF NOT FND_API.Compatible_API_Call (
3626: l_api_version,
3627: p_api_version,
3628: l_api_name,
3655: ,l_api_message);
3656: END IF;
3657:
3658:
3659: -- Standard check of p_commit
3660: IF FND_API.to_Boolean(p_commit) THEN
3661: COMMIT WORK;
3662: END IF;
3663:
3660: IF FND_API.to_Boolean(p_commit) THEN
3661: COMMIT WORK;
3662: END IF;
3663:
3664: -- Standard Call to get message count and if count = 1, get message info
3665: FND_MSG_PUB.Count_And_Get (
3666: p_count => x_msg_count,
3667: p_data => x_msg_data );
3668:
3769:
3770: invalid_event EXCEPTION;
3771: BEGIN
3772:
3773: -- Standard start of API savepoint
3774: SAVEPOINT Insert_MMTEvents_PVT;
3775:
3776: l_stmt_num := 0;
3777:
3779: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,G_LOG_HEAD ||l_api_name||'.begin'
3780: ,'Insert_MMTEvents <<');
3781: END IF;
3782:
3783: -- Standard call to check for call compatibility
3784: IF NOT FND_API.Compatible_API_Call (
3785: l_api_version,
3786: p_api_version,
3787: l_api_name,
4092: END IF;
4093:
4094: -- End API Body
4095:
4096: -- Standard check of p_commit
4097: IF FND_API.to_Boolean(p_commit) THEN
4098: COMMIT WORK;
4099: END IF;
4100:
4247:
4248: invalid_txn_type EXCEPTION;
4249: BEGIN
4250:
4251: -- Standard start of API savepoint
4252: SAVEPOINT Create_MMTRecord_PVT;
4253:
4254: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4255: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,G_LOG_HEAD ||'.'||l_api_name||'.begin'
4255: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,G_LOG_HEAD ||'.'||l_api_name||'.begin'
4256: ,'Create_MMTRecord <<');
4257: END IF;
4258:
4259: -- Standard call to check for call compatibility
4260: IF NOT FND_API.Compatible_API_Call (
4261: l_api_version,
4262: p_api_version,
4263: l_api_name,
4460:
4461: X_INV_TRX := l_inv_trx;
4462: -- ***************
4463:
4464: -- Standard check of p_commit
4465: IF FND_API.to_Boolean(p_commit) THEN
4466: COMMIT WORK;
4467: END IF;
4468:
4465: IF FND_API.to_Boolean(p_commit) THEN
4466: COMMIT WORK;
4467: END IF;
4468:
4469: -- Standard Call to get message count and if count = 1, get message info
4470: FND_MSG_PUB.Count_And_Get (
4471: p_count => x_msg_count,
4472: p_data => x_msg_data );
4473: