DBA Data[Home] [Help]

APPS.PSB_POSITION_PAY_DISTR_PVT dependencies on STANDARD

Line 226: -- Standard check of p_commit.

222: --
223: --
224: p_return_status := FND_API.G_RET_STS_SUCCESS ;
225:
226: -- Standard check of p_commit.
227: if FND_API.to_Boolean (p_commit) then
228: commit work;
229: end if;
230: -- Standard call to get message count and if count is 1, get message info.

Line 230: -- Standard call to get message count and if count is 1, get message info.

226: -- Standard check of p_commit.
227: if FND_API.to_Boolean (p_commit) then
228: commit work;
229: end if;
230: -- Standard call to get message count and if count is 1, get message info.
231: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
232: p_data => p_msg_data);
233: --
234: EXCEPTION

Line 545: -- Standard check of p_commit.

541: p_return_status := FND_API.G_RET_STS_SUCCESS ;
542:
543: --
544: --
545: -- Standard check of p_commit.
546:
547: if FND_API.to_Boolean (p_commit) then
548: commit work;
549: end if;

Line 551: -- Standard call to get message count and if count is 1, get message info.

547: if FND_API.to_Boolean (p_commit) then
548: commit work;
549: end if;
550:
551: -- Standard call to get message count and if count is 1, get message info.
552:
553: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
554: p_data => p_msg_data);
555: --

Line 672: -- Standard call to get message count and if count is 1, get message info.

668: --
669: if FND_API.to_Boolean (p_commit) then
670: commit work;
671: end if;
672: -- Standard call to get message count and if count is 1, get message info.
673: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
674: p_data => p_msg_data);
675:
676: return;

Line 702: -- Standard check of p_commit.

698: p_expenditure_organization_id => p_expenditure_organization_id,
699: p_description => p_description,
700: p_mode => p_mode
701: );
702: -- Standard check of p_commit.
703:
704: if FND_API.to_Boolean (p_commit) then
705: commit work;
706: end if;

Line 708: -- Standard call to get message count and if count is 1, get message info.

704: if FND_API.to_Boolean (p_commit) then
705: commit work;
706: end if;
707:
708: -- Standard call to get message count and if count is 1, get message info.
709:
710: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
711: p_data => p_msg_data);
712:

Line 750: -- Standard check of p_commit.

746: if (sql%notfound) THEN
747: null;
748: end if;
749:
750: -- Standard check of p_commit.
751: --
752: if FND_API.to_Boolean (p_commit) then
753: commit work;
754: end if;

Line 756: -- Standard call to get message count and if count is 1, get message info.

752: if FND_API.to_Boolean (p_commit) then
753: commit work;
754: end if;
755:
756: -- Standard call to get message count and if count is 1, get message info.
757:
758: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
759: p_data => p_msg_data);
760: --

Line 807: -- Standard Start of API savepoint

803: l_api_version CONSTANT NUMBER := 1.0;
804:
805: BEGIN
806:
807: -- Standard Start of API savepoint
808:
809: SAVEPOINT Delete_Distributions_Pvt;
810:
811:

Line 812: -- Standard call to check for call compatibility

808:
809: SAVEPOINT Delete_Distributions_Pvt;
810:
811:
812: -- Standard call to check for call compatibility
813:
814: if not FND_API.Compatible_API_Call (l_api_version,
815: p_api_version,
816: l_api_name,

Line 833: -- Standard check of p_commit

829: delete from PSB_POSITION_PAY_DISTRIBUTIONS
830: where data_extract_id = p_data_extract_id;
831:
832:
833: -- Standard check of p_commit
834:
835: if FND_API.to_Boolean (p_commit) then
836: commit work;
837: end if;

Line 845: -- Standard call to get message count and if count is 1, get message info

841:
842: p_return_status := FND_API.G_RET_STS_SUCCESS;
843:
844:
845: -- Standard call to get message count and if count is 1, get message info
846:
847: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
848: p_data => p_msg_data);
849:

Line 902: -- Standard Start of API savepoint

898: l_api_version CONSTANT NUMBER := 1.0;
899:
900: BEGIN
901:
902: -- Standard Start of API savepoint
903:
904: SAVEPOINT Delete_Dist_Position_Pvt;
905:
906:

Line 907: -- Standard call to check for call compatibility

903:
904: SAVEPOINT Delete_Dist_Position_Pvt;
905:
906:
907: -- Standard call to check for call compatibility
908:
909: if not FND_API.Compatible_API_Call (l_api_version,
910: p_api_version,
911: l_api_name,

Line 932: -- Standard check of p_commit

928: OR worksheet_id = p_worksheet_id);
929: /* Bug 4545909 End */
930:
931:
932: -- Standard check of p_commit
933:
934: if FND_API.to_Boolean (p_commit) then
935: commit work;
936: end if;

Line 944: -- Standard call to get message count and if count is 1, get message info

940:
941: p_return_status := FND_API.G_RET_STS_SUCCESS;
942:
943:
944: -- Standard call to get message count and if count is 1, get message info
945:
946: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
947: p_data => p_msg_data);
948:

Line 1081: -- Standard Start of API savepoint

1077: FROM psb_data_extracts
1078: WHERE data_extract_id = l_data_extract_id ;
1079: BEGIN
1080:
1081: -- Standard Start of API savepoint
1082:
1083: SAVEPOINT Modify_Distribution_WS_Pvt;
1084:
1085:

Line 1086: -- Standard call to check for call compatibility

1082:
1083: SAVEPOINT Modify_Distribution_WS_Pvt;
1084:
1085:
1086: -- Standard call to check for call compatibility
1087:
1088: if not FND_API.Compatible_API_Call (l_api_version,
1089: p_api_version,
1090: l_api_name,

Line 1332: -- Standard check of p_commit

1328: raise FND_API.G_EXC_ERROR;
1329: end if;
1330:
1331:
1332: -- Standard check of p_commit
1333:
1334: if FND_API.to_Boolean (p_commit) then
1335: commit work;
1336: end if;

Line 1344: -- Standard call to get message count and if count is 1, get message info

1340:
1341: p_return_status := FND_API.G_RET_STS_SUCCESS;
1342:
1343:
1344: -- Standard call to get message count and if count is 1, get message info
1345:
1346: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1347: p_data => p_msg_data);
1348:

Line 1471: -- Standard Start of API savepoint

1467: and position_id = p_position_id;
1468:
1469: BEGIN
1470:
1471: -- Standard Start of API savepoint
1472:
1473: SAVEPOINT Modify_Distribution_Pvt;
1474:
1475:

Line 1476: -- Standard call to check for call compatibility

1472:
1473: SAVEPOINT Modify_Distribution_Pvt;
1474:
1475:
1476: -- Standard call to check for call compatibility
1477:
1478: if not FND_API.Compatible_API_Call (l_api_version,
1479: p_api_version,
1480: l_api_name,

Line 2109: -- Standard check of p_commit

2105:
2106: end; -- SQL%NOTFOUND
2107: end if;
2108:
2109: -- Standard check of p_commit
2110:
2111: if FND_API.to_Boolean (p_commit) then
2112: commit work;
2113: end if;

Line 2121: -- Standard call to get message count and if count is 1, get message info

2117:
2118: p_return_status := FND_API.G_RET_STS_SUCCESS;
2119:
2120:
2121: -- Standard call to get message count and if count is 1, get message info
2122:
2123: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
2124: p_data => p_msg_data);
2125:

Line 2326: -- Standard Start of API savepoint

2322:
2323:
2324: BEGIN
2325:
2326: -- Standard Start of API savepoint
2327:
2328: SAVEPOINT Modify_Extract_Dist_Pvt;
2329:
2330:

Line 2331: -- Standard call to check for call compatibility

2327:
2328: SAVEPOINT Modify_Extract_Dist_Pvt;
2329:
2330:
2331: -- Standard call to check for call compatibility
2332:
2333: if not FND_API.Compatible_API_Call (l_api_version,
2334: p_api_version,
2335: l_api_name,

Line 2456: -- Standard check of p_commit

2452:
2453: end if;
2454: End Loop;
2455:
2456: -- Standard check of p_commit
2457:
2458: if FND_API.to_Boolean (p_commit) then
2459: commit work;
2460: end if;

Line 2468: -- Standard call to get message count and if count is 1, get message info

2464:
2465: p_return_status := FND_API.G_RET_STS_SUCCESS;
2466:
2467:
2468: -- Standard call to get message count and if count is 1, get message info
2469:
2470: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
2471: p_data => p_msg_data);
2472:

Line 2693: -- Standard Start of API savepoint

2689: /* Bug 4545909 End */
2690:
2691: BEGIN
2692:
2693: -- Standard Start of API savepoint
2694:
2695: SAVEPOINT Apply_Position_Pay_Distr;
2696:
2697:

Line 2698: -- Standard call to check for call compatibility

2694:
2695: SAVEPOINT Apply_Position_Pay_Distr;
2696:
2697:
2698: -- Standard call to check for call compatibility
2699:
2700: IF NOT FND_API.Compatible_API_Call (l_api_version,
2701: p_api_version,
2702: l_api_name,

Line 2919: -- Standard check of p_commit

2915: END IF;
2916: END IF;
2917: END IF;
2918:
2919: -- Standard check of p_commit
2920:
2921: IF FND_API.to_Boolean (p_commit) THEN
2922: COMMIT WORK;
2923: END IF;

Line 2931: -- Standard call to get message count and if count is 1, get message info

2927:
2928: x_return_status := FND_API.G_RET_STS_SUCCESS;
2929:
2930:
2931: -- Standard call to get message count and if count is 1, get message info
2932:
2933: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
2934: p_data => x_msg_data);
2935: