42:
43:
44: BEGIN
45: --
46: -- Standard Start of API savepoint
47: --
48: SAVEPOINT Refresh_Payrun;
49: --
50: -- Standard call to check for call compatibility.
46: -- Standard Start of API savepoint
47: --
48: SAVEPOINT Refresh_Payrun;
49: --
50: -- Standard call to check for call compatibility.
51: --
52: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
53: p_api_version ,
54: l_api_name ,
150: END LOOP;
151:
152:
153: -- End of API body.
154: -- Standard check of p_commit.
155:
156: IF FND_API.To_Boolean( p_commit ) THEN
157: COMMIT WORK;
158: END IF;
157: COMMIT WORK;
158: END IF;
159:
160: --
161: -- Standard call to get message count and if count is 1, get message info.
162: --
163: FND_MSG_PUB.Count_And_Get
164: (
165: p_count => x_msg_count ,
672:
673: x_batch_id := l_batch_id;
674:
675: -- End of Building and Calling BEE API
676: -- Standard call to get message count and if count is 1,
677: -- get message info.
678:
679: FND_MSG_PUB.Count_And_Get
680: (
778: END LOOP;
779:
780:
781: -- End of Building and Calling BEE API
782: -- Standard call to get message count and if count is 1,
783: -- get message info.
784:
785: FND_MSG_PUB.Count_And_Get
786: (
1529: AND cnr.org_id = cnp.org_id
1530: AND cnp.payrun_id= p_payrun_id;
1531: l_functional_currency gl_sets_of_books.currency_code%TYPE;
1532:
1533: l_lookup_type VARCHAR2(30) := 'STANDARD';
1534: l_org_id number;
1535: l_supplier_id po_vendor_sites.vendor_id%TYPE;
1536: l_supplier_site_id po_vendor_sites.vendor_site_id%TYPE;
1537:
1577: --
1578: IF nvl(invoice.payment_amount,0) < 0 THEN
1579: l_lookup_type := 'CREDIT';
1580: ELSE
1581: l_lookup_type := 'STANDARD';
1582: END IF;
1583:
1584: INSERT INTO ap_invoices_interface
1585: (invoice_id,
1816: l_profile_value VARCHAR2(1);
1817:
1818: BEGIN
1819: --
1820: -- Standard Start of API savepoint
1821: --
1822: SAVEPOINT Create_Payrun;
1823: --
1824: -- Standard call to check for call compatibility.
1820: -- Standard Start of API savepoint
1821: --
1822: SAVEPOINT Create_Payrun;
1823: --
1824: -- Standard call to check for call compatibility.
1825: --
1826: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1827: p_api_version ,
1828: l_api_name ,
2060: p_type => 'PAYRUN',
2061: p_event_name => 'create',
2062: p_payrun_id => p_payrun_rec.payrun_id ) ;
2063:
2064: -- Standard check of p_commit.
2065: IF FND_API.To_Boolean( p_commit ) THEN
2066: COMMIT WORK;
2067: END IF;
2068:
2066: COMMIT WORK;
2067: END IF;
2068:
2069: --
2070: -- Standard call to get message count and if count is 1, get message info.
2071: --
2072:
2073: FND_MSG_PUB.Count_And_Get
2074: (
2168: l_has_access BOOLEAN;
2169:
2170: BEGIN
2171:
2172: -- Standard Start of API savepoint
2173: SAVEPOINT Update_Payrun;
2174:
2175: -- Standard call to check for call compatibility.
2176: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
2171:
2172: -- Standard Start of API savepoint
2173: SAVEPOINT Update_Payrun;
2174:
2175: -- Standard call to check for call compatibility.
2176: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
2177: p_api_version ,
2178: l_api_name ,
2179: G_PKG_NAME )
2317: x_jtf_note_id => l_note_id -- returned
2318: );
2319:
2320: -- End of API body.
2321: -- Standard check of p_commit.
2322:
2323: IF FND_API.To_Boolean( p_commit ) THEN
2324: COMMIT WORK;
2325: END IF;
2323: IF FND_API.To_Boolean( p_commit ) THEN
2324: COMMIT WORK;
2325: END IF;
2326:
2327: -- Standard call to get message count and if count is 1, get message info.
2328: FND_MSG_PUB.Count_And_Get
2329: (
2330: p_count => x_msg_count ,
2331: p_data => x_msg_data ,
2417: l_pmtbatch_name VARCHAR2(80);
2418:
2419: BEGIN
2420: --
2421: -- Standard Start of API savepoint
2422: --
2423: SAVEPOINT Delete_Payrun;
2424: --
2425: -- Standard call to check for call compatibility.
2421: -- Standard Start of API savepoint
2422: --
2423: SAVEPOINT Delete_Payrun;
2424: --
2425: -- Standard call to check for call compatibility.
2426: --
2427: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
2428: p_api_version ,
2429: l_api_name ,
2529:
2530: x_loading_status := 'CN_DELETED';
2531:
2532: -- End of API body.
2533: -- Standard check of p_commit.
2534: IF (l_org_id <> -999) THEN
2535: fnd_message.set_name ('CN', 'CN_PMT_DEL_NOTE');
2536: fnd_message.set_token ('PMTBATCH_NAME', l_pmtbatch_name);
2537: l_note_msg := fnd_message.get;
2554: COMMIT WORK;
2555: END IF;
2556:
2557: --
2558: -- Standard call to get message count and if count is 1, get message info.
2559: --
2560: FND_MSG_PUB.Count_And_Get
2561: (
2562: p_count => x_msg_count ,
2629: AND quota_id IS NULL;
2630:
2631: BEGIN
2632: --
2633: -- Standard Start of API savepoint
2634: --
2635: SAVEPOINT Pay_Payrun_Approve_Wksht;
2636: --
2637: -- Initialize API return status to success
2707:
2708: -- End of API body
2709:
2710: --
2711: -- Standard call to get message count and if count is 1, get message info.
2712: --
2713:
2714: FND_MSG_PUB.Count_And_Get
2715: (p_count => x_msg_count ,
2974: l_has_access BOOLEAN;
2975:
2976: BEGIN
2977: --
2978: -- Standard Start of API savepoint
2979: --
2980: SAVEPOINT Pay_Payrun;
2981: --
2982: -- Standard call to check for call compatibility.
2978: -- Standard Start of API savepoint
2979: --
2980: SAVEPOINT Pay_Payrun;
2981: --
2982: -- Standard call to check for call compatibility.
2983: --
2984: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
2985: p_api_version ,
2986: l_api_name ,
3392: );
3393:
3394:
3395: -- End of API body
3396: -- Standard check of p_commit.
3397: IF FND_API.To_Boolean( p_commit ) THEN
3398: COMMIT WORK;
3399: END IF;
3400:
3398: COMMIT WORK;
3399: END IF;
3400:
3401: --
3402: -- Standard call to get message count and if count is 1, get message info.
3403: --
3404:
3405: FND_MSG_PUB.Count_And_Get
3406: (