55: l_api_name CONSTANT VARCHAR2(30) := 'Initialize_Batch';
56: l_api_version CONSTANT NUMBER := 1.0;
57: l_count NUMBER;
58: BEGIN
59: -- Standard Start of API savepoint
60: SAVEPOINT Initialize_Batch;
61: -- Standard call to check for call compatibility.
62: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
63: p_api_version ,
57: l_count NUMBER;
58: BEGIN
59: -- Standard Start of API savepoint
60: SAVEPOINT Initialize_Batch;
61: -- Standard call to check for call compatibility.
62: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
63: p_api_version ,
64: l_api_name ,
65: G_PKG_NAME ) THEN
89: RAISE FND_API.G_EXC_ERROR;
90: END IF;
91: END IF;
92: -- End of API body.
93: -- Standard check of p_commit.
94: IF FND_API.To_Boolean( p_commit ) THEN
95: COMMIT WORK;
96: END IF;
97: -- Standard call to get message count and if count is 1, get message info.
93: -- Standard check of p_commit.
94: IF FND_API.To_Boolean( p_commit ) THEN
95: COMMIT WORK;
96: END IF;
97: -- Standard call to get message count and if count is 1, get message info.
98: FND_MSG_PUB.Count_And_Get
99: ( p_count => x_msg_count ,
100: p_data => x_msg_data
101: );
215: x_status := 'CANNOT CREATE REVERT FOR COMMISSION LINE HAS BEEN POSTED OR REVERTED ALREADY.';
216: RAISE FND_API.G_EXC_ERROR;
217: END IF;
218: -- End of Validate Posting
219: -- Standard call to get message count and if count is 1, get message info.
220: FND_MSG_PUB.Count_And_Get
221: ( p_count => x_msg_count ,
222: p_data => x_msg_data ,
223: p_encoded => FND_API.G_FALSE
406: -- AND cl.processed_date BETWEEN srcp.start_date AND Nvl(srcp.end_date, cl.processed_date)
407: -- AND srcp.role_plan_id = rcp.role_plan_id (+)
408:
409: BEGIN
410: -- Standard Start of API savepoint
411: SAVEPOINT Create_From_CommLine;
412: -- Standard call to check for call compatibility.
413: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
414: p_api_version ,
408:
409: BEGIN
410: -- Standard Start of API savepoint
411: SAVEPOINT Create_From_CommLine;
412: -- Standard call to check for call compatibility.
413: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
414: p_api_version ,
415: l_api_name ,
416: G_PKG_NAME ) THEN
527: WHERE commission_line_id = p_commission_line_id;
528: END IF;
529: END IF;
530: -- End of API body.
531: -- Standard check of p_commit.
532: IF FND_API.To_Boolean( p_commit ) THEN
533: COMMIT WORK;
534: END IF;
535: -- Standard call to get message count and if count is 1, get message info
531: -- Standard check of p_commit.
532: IF FND_API.To_Boolean( p_commit ) THEN
533: COMMIT WORK;
534: END IF;
535: -- Standard call to get message count and if count is 1, get message info
536: FND_MSG_PUB.Count_And_Get
537: ( p_count => x_msg_count ,
538: p_data => x_msg_data
539: );
604: l_api_version CONSTANT NUMBER := 1.0;
605: l_loading_status VARCHAR2(30);
606: l_status VARCHAR2(30);
607: BEGIN
608: -- Standard Start of API savepoint
609: SAVEPOINT Create_PrePostDetails;
610: -- Standard call to check for call compatibility.
611: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
612: p_api_version ,
606: l_status VARCHAR2(30);
607: BEGIN
608: -- Standard Start of API savepoint
609: SAVEPOINT Create_PrePostDetails;
610: -- Standard call to check for call compatibility.
611: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
612: p_api_version ,
613: l_api_name ,
614: G_PKG_NAME ) THEN
651: END IF;
652: l_status := 'CREATED POSTING DETAIL '||TO_CHAR(i);
653: END LOOP;
654: -- End of API body.
655: -- Standard check of p_commit.
656: IF FND_API.To_Boolean( p_commit ) THEN
657: COMMIT WORK;
658: END IF;
659: -- Standard call to get message count and if count is 1, get message info.
655: -- Standard check of p_commit.
656: IF FND_API.To_Boolean( p_commit ) THEN
657: COMMIT WORK;
658: END IF;
659: -- Standard call to get message count and if count is 1, get message info.
660: FND_MSG_PUB.Count_And_Get
661: ( p_count => x_msg_count ,
662: p_data => x_msg_data
663: );
771: where ws.payrun_id = pr.payrun_id
772: and ws.posting_status = C_UNPOSTED
773: );
774: BEGIN
775: -- Standard Start of API savepoint
776: SAVEPOINT PrePost_PayWorksheets;
777: -- Standard call to check for call compatibility.
778: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
779: p_api_version ,
773: );
774: BEGIN
775: -- Standard Start of API savepoint
776: SAVEPOINT PrePost_PayWorksheets;
777: -- Standard call to check for call compatibility.
778: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
779: p_api_version ,
780: l_api_name ,
781: G_PKG_NAME ) THEN
1028: */
1029: end loop;
1030:
1031: -- End of API body.
1032: -- Standard check of p_commit.
1033: IF FND_API.To_Boolean( p_commit ) THEN
1034: COMMIT WORK;
1035: END IF;
1036: -- Standard call to get message count and if count is 1, get message info.
1032: -- Standard check of p_commit.
1033: IF FND_API.To_Boolean( p_commit ) THEN
1034: COMMIT WORK;
1035: END IF;
1036: -- Standard call to get message count and if count is 1, get message info.
1037: FND_MSG_PUB.Count_And_Get
1038: ( p_count => x_msg_count ,
1039: p_data => x_msg_data
1040: );