DBA Data[Home] [Help]

APPS.AP_VENDOR_PUB_PKG dependencies on STANDARD

Line 3531: -- Standard Start of API savepoint

3527: L_PARTY_TAX_PROFILE_ID zx_party_tax_profile.party_tax_profile_id%type; -- B 9202909
3528: l_return_status VARCHAR2(50); -- B 9202909
3529:
3530: BEGIN
3531: -- Standard Start of API savepoint
3532: SAVEPOINT Create_Vendor_PUB;
3533:
3534: -- Standard call to check for call compatibility.
3535: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

Line 3534: -- Standard call to check for call compatibility.

3530: BEGIN
3531: -- Standard Start of API savepoint
3532: SAVEPOINT Create_Vendor_PUB;
3533:
3534: -- Standard call to check for call compatibility.
3535: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
3536: p_api_version ,
3537: l_api_name ,
3538: G_PKG_NAME )

Line 4059: -- Standard check of p_commit.

4055: END IF; --Supplier Valid
4056:
4057: -- End of API body.
4058:
4059: -- Standard check of p_commit.
4060: IF FND_API.To_Boolean( p_commit ) THEN
4061: COMMIT WORK;
4062: END IF;
4063:

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

4060: IF FND_API.To_Boolean( p_commit ) THEN
4061: COMMIT WORK;
4062: END IF;
4063:
4064: -- Standard call to get message count and if count is 1,
4065: -- get message info.
4066: FND_MSG_PUB.Count_And_Get(
4067: p_count => x_msg_count ,
4068: p_data => x_msg_data

Line 4142: -- Standard Start of API savepoint

4138: l_org_party_id NUMBER;
4139:
4140:
4141: BEGIN
4142: -- Standard Start of API savepoint
4143: SAVEPOINT Update_Vendor_PUB;
4144:
4145: -- Standard call to check for call compatibility.
4146: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

Line 4145: -- Standard call to check for call compatibility.

4141: BEGIN
4142: -- Standard Start of API savepoint
4143: SAVEPOINT Update_Vendor_PUB;
4144:
4145: -- Standard call to check for call compatibility.
4146: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
4147: p_api_version ,
4148: l_api_name ,
4149: G_PKG_NAME )

Line 4748: -- Standard check of p_commit.

4744: END IF;
4745:
4746: -- End of API body.
4747:
4748: -- Standard check of p_commit.
4749: IF FND_API.To_Boolean( p_commit ) THEN
4750: COMMIT WORK;
4751: END IF;
4752:

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

4749: IF FND_API.To_Boolean( p_commit ) THEN
4750: COMMIT WORK;
4751: END IF;
4752:
4753: -- Standard call to get message count and if count is 1,
4754: -- get message info.
4755: FND_MSG_PUB.Count_And_Get(
4756: p_count => x_msg_count ,
4757: p_data => x_msg_data

Line 4829: -- Standard Start of API savepoint

4825:
4826: BEGIN
4827: current_calling_sequence := 'AP_VENDOR_PUB_PKG.Validate_Vendor<-'
4828: ||p_calling_prog; --Bug#13464635
4829: -- Standard Start of API savepoint
4830: SAVEPOINT Validate_Vendor_PUB;
4831:
4832: -- Standard call to check for call compatibility.
4833: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

Line 4832: -- Standard call to check for call compatibility.

4828: ||p_calling_prog; --Bug#13464635
4829: -- Standard Start of API savepoint
4830: SAVEPOINT Validate_Vendor_PUB;
4831:
4832: -- Standard call to check for call compatibility.
4833: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
4834: p_api_version ,
4835: l_api_name ,
4836: G_PKG_NAME )

Line 7625: -- Standard check of p_commit.

7621: END IF; --p_mode
7622:
7623: -- End of API body
7624:
7625: -- Standard check of p_commit.
7626: IF FND_API.To_Boolean( p_commit ) THEN
7627: COMMIT WORK;
7628: END IF;
7629:

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

7626: IF FND_API.To_Boolean( p_commit ) THEN
7627: COMMIT WORK;
7628: END IF;
7629:
7630: -- Standard call to get message count and if count is 1,
7631: -- get message info.
7632: FND_MSG_PUB.Count_And_Get(
7633: p_count => x_msg_count ,
7634: p_data => x_msg_data

Line 7937: -- Standard Start of API savepoint

7933: l_site_use_msg_data VARCHAR2(2000);
7934: l_party_site_use_id NUMBER;
7935: /* Bug 12334398 end */
7936: BEGIN
7937: -- Standard Start of API savepoint
7938: SAVEPOINT Create_Vendor_Site_PUB;
7939:
7940: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
7941: p_api_version ,

Line 9131: -- Standard check of p_commit.

9127: END IF;
9128:
9129: -- End of API body.
9130:
9131: -- Standard check of p_commit.
9132: IF FND_API.To_Boolean( p_commit ) THEN
9133: COMMIT WORK;
9134: END IF;
9135:

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

9132: IF FND_API.To_Boolean( p_commit ) THEN
9133: COMMIT WORK;
9134: END IF;
9135:
9136: -- Standard call to get message count and if count is 1,
9137: -- get message info.
9138: FND_MSG_PUB.Count_And_Get(
9139: p_count => x_msg_count ,
9140: p_data => x_msg_data

Line 9231: -- Standard Start of API savepoint

9227:
9228:
9229:
9230: BEGIN
9231: -- Standard Start of API savepoint
9232: SAVEPOINT Update_Vendor_Site_PUB;
9233:
9234: -- Standard call to check for call compatibility.
9235: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

Line 9234: -- Standard call to check for call compatibility.

9230: BEGIN
9231: -- Standard Start of API savepoint
9232: SAVEPOINT Update_Vendor_Site_PUB;
9233:
9234: -- Standard call to check for call compatibility.
9235: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
9236: p_api_version ,
9237: l_api_name ,
9238: G_PKG_NAME )

Line 9877: -- Standard check of p_commit.

9873: END IF;
9874:
9875: -- End of API body.
9876:
9877: -- Standard check of p_commit.
9878: IF FND_API.To_Boolean( p_commit ) THEN
9879: COMMIT WORK;
9880: END IF;
9881:

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

9878: IF FND_API.To_Boolean( p_commit ) THEN
9879: COMMIT WORK;
9880: END IF;
9881:
9882: -- Standard call to get message count and if count is 1,
9883: -- get message info.
9884: FND_MSG_PUB.Count_And_Get(
9885: p_count => x_msg_count ,
9886: p_data => x_msg_data

Line 9986: -- Standard Start of API savepoint

9982: IF nvl(l_org_context, 'K') <> 'S' THEN
9983: MO_GLOBAL.set_policy_context('S',p_vendor_site_rec.org_id);
9984: END IF;
9985: --Bug 7476500 End
9986: -- Standard Start of API savepoint
9987: SAVEPOINT Validate_Vendor_Site_PUB;
9988:
9989: -- Standard call to check for call compatibility.
9990: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

Line 9989: -- Standard call to check for call compatibility.

9985: --Bug 7476500 End
9986: -- Standard Start of API savepoint
9987: SAVEPOINT Validate_Vendor_Site_PUB;
9988:
9989: -- Standard call to check for call compatibility.
9990: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
9991: p_api_version ,
9992: l_api_name ,
9993: G_PKG_NAME )

Line 13750: -- Standard check of p_commit.

13746: END IF; --p_mode
13747:
13748: -- End of API body.
13749:
13750: -- Standard check of p_commit.
13751: IF FND_API.To_Boolean( p_commit ) THEN
13752: COMMIT WORK;
13753: END IF;
13754:

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

13751: IF FND_API.To_Boolean( p_commit ) THEN
13752: COMMIT WORK;
13753: END IF;
13754:
13755: -- Standard call to get message count and if count is 1,
13756: -- get message info.
13757: FND_MSG_PUB.Count_And_Get(
13758: p_count => x_msg_count ,
13759: p_data => x_msg_data

Line 13895: -- Standard Start of API savepoint

13891: l_debug_info VARCHAR2(500); -- Bug 6823885
13892: l_party_site_num VARCHAR2(1); -- Bug 6823885
13893:
13894: BEGIN
13895: -- Standard Start of API savepoint
13896: SAVEPOINT Create_Vendor_Contact_PUB;
13897:
13898: -- Standard call to check for call compatibility.
13899: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

Line 13898: -- Standard call to check for call compatibility.

13894: BEGIN
13895: -- Standard Start of API savepoint
13896: SAVEPOINT Create_Vendor_Contact_PUB;
13897:
13898: -- Standard call to check for call compatibility.
13899: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
13900: p_api_version ,
13901: l_api_name ,
13902: G_PKG_NAME )

Line 14815: -- Standard check of p_commit.

14811: END IF;
14812:
14813: -- End of API body.
14814:
14815: -- Standard check of p_commit.
14816: IF FND_API.To_Boolean( p_commit ) THEN
14817: COMMIT WORK;
14818: END IF;
14819: /* Bug 12590128 start */

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

14835: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
14836: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,x_msg_data);
14837: END IF;
14838: END IF; /* Bug 12590128 end */
14839: -- Standard call to get message count and if count is 1,
14840: -- get message info.
14841: FND_MSG_PUB.Count_And_Get(
14842: p_count => x_msg_count ,
14843: p_data => x_msg_data

Line 14893: -- Standard Start of API savepoint

14889: l_api_name CONSTANT VARCHAR2(30) := 'Update_Vendor_Contact';
14890: l_api_version CONSTANT NUMBER := 1.0;
14891:
14892: BEGIN
14893: -- Standard Start of API savepoint
14894: SAVEPOINT Update_Vendor_Contact_PUB;
14895:
14896: -- Standard call to check for call compatibility.
14897: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

Line 14896: -- Standard call to check for call compatibility.

14892: BEGIN
14893: -- Standard Start of API savepoint
14894: SAVEPOINT Update_Vendor_Contact_PUB;
14895:
14896: -- Standard call to check for call compatibility.
14897: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
14898: p_api_version ,
14899: l_api_name ,
14900: G_PKG_NAME )

Line 14944: -- Standard check of p_commit.

14940: END IF;
14941:
14942: -- End of API body.
14943:
14944: -- Standard check of p_commit.
14945: IF FND_API.To_Boolean( p_commit ) THEN
14946: COMMIT WORK;
14947: END IF;
14948:

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

14945: IF FND_API.To_Boolean( p_commit ) THEN
14946: COMMIT WORK;
14947: END IF;
14948:
14949: -- Standard call to get message count and if count is 1,
14950: -- get message info.
14951: FND_MSG_PUB.Count_And_Get(
14952: p_count => x_msg_count ,
14953: p_data => x_msg_data

Line 15019: -- Standard Start of API savepoint

15015:
15016: -- Bug 7013954 The validation logic is modified to accomodate the changes
15017: -- related to contacts. The Contacts are now associated at Party Site/Address
15018: -- or at Supplier level. Supplier Site level association is deprecated in R12.
15019: -- Standard Start of API savepoint
15020: SAVEPOINT Validate_Vendor_Contact_PUB;
15021:
15022: -- Standard call to check for call compatibility.
15023: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

Line 15022: -- Standard call to check for call compatibility.

15018: -- or at Supplier level. Supplier Site level association is deprecated in R12.
15019: -- Standard Start of API savepoint
15020: SAVEPOINT Validate_Vendor_Contact_PUB;
15021:
15022: -- Standard call to check for call compatibility.
15023: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
15024: p_api_version ,
15025: l_api_name ,
15026: G_PKG_NAME )

Line 15675: -- Standard check of p_commit.

15671: x_org_contact_valid := 'N';
15672: END IF;
15673: -- End of API body.
15674:
15675: -- Standard check of p_commit.
15676: IF FND_API.To_Boolean( p_commit ) THEN
15677: COMMIT WORK;
15678: END IF;
15679:

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

15676: IF FND_API.To_Boolean( p_commit ) THEN
15677: COMMIT WORK;
15678: END IF;
15679:
15680: -- Standard call to get message count and if count is 1,
15681: -- get message info.
15682: FND_MSG_PUB.Count_And_Get(
15683: p_count => x_msg_count ,
15684: p_data => x_msg_data

Line 15788: -- Standard Start of API savepoint

15784: l_allow_dupe_taxpyr_id varchar2(1) := 'N';
15785:
15786: BEGIN
15787:
15788: -- Standard Start of API savepoint
15789: SAVEPOINT Import_Vendor_PUB;
15790:
15791: -- Standard call to check for call compatibility.
15792: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 15791: -- Standard call to check for call compatibility.

15787:
15788: -- Standard Start of API savepoint
15789: SAVEPOINT Import_Vendor_PUB;
15790:
15791: -- Standard call to check for call compatibility.
15792: IF NOT FND_API.Compatible_API_Call (l_api_version,
15793: p_api_version,
15794: l_api_name,
15795: G_PKG_NAME )

Line 15978: vendor_rec.SIC_Code := vendor_int_rec.standard_industry_class;

15974: vendor_rec.end_date_active := vendor_int_rec.end_date_active;
15975: vendor_rec.minority_group_lookup_code := vendor_int_rec.minority_group_lookup_code;
15976: vendor_rec.women_owned_flag := vendor_int_rec.women_owned_flag;
15977: vendor_rec.small_business_flag := vendor_int_rec.small_business_flag;
15978: vendor_rec.SIC_Code := vendor_int_rec.standard_industry_class;
15979: vendor_rec.hold_flag := vendor_int_rec.hold_flag;
15980: vendor_rec.purchasing_hold_reason := vendor_int_rec.purchasing_hold_reason;
15981: vendor_rec.hold_by := vendor_int_rec.hold_by;
15982: vendor_rec.hold_date := vendor_int_rec.hold_date;

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

16536: -- End of API body.
16537:
16538: COMMIT WORK;
16539:
16540: -- Standard call to get message count and if count is 1,
16541: -- get message info.
16542: FND_MSG_PUB.Count_And_Get(
16543: p_count => x_msg_count,
16544: p_data => x_msg_data

Line 16649: -- Standard Start of API savepoint

16645: l_payee_msg_data VARCHAR2(4000); --Bug 7572325
16646: l_error_code VARCHAR2(4000); --Bug 7572325
16647: BEGIN
16648:
16649: -- Standard Start of API savepoint
16650: SAVEPOINT Import_Vendor_Sites_PUB;
16651:
16652: -- Standard call to check for call compatibility.
16653: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 16652: -- Standard call to check for call compatibility.

16648:
16649: -- Standard Start of API savepoint
16650: SAVEPOINT Import_Vendor_Sites_PUB;
16651:
16652: -- Standard call to check for call compatibility.
16653: IF NOT FND_API.Compatible_API_Call (l_api_version,
16654: p_api_version,
16655: l_api_name,
16656: G_PKG_NAME )

Line 17481: -- Standard check of p_commit.

17477:
17478: END IF;
17479: -- End of API body.
17480:
17481: -- Standard check of p_commit.
17482: COMMIT WORK;
17483:
17484: -- Standard call to get message count and if count is 1,
17485: -- get message info.

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

17480:
17481: -- Standard check of p_commit.
17482: COMMIT WORK;
17483:
17484: -- Standard call to get message count and if count is 1,
17485: -- get message info.
17486: FND_MSG_PUB.Count_And_Get(
17487: p_count => x_msg_count,
17488: p_data => x_msg_data

Line 17569: -- Standard call to check for call compatibility.

17565: vendor_contact_rec r_vendor_contact_rec_type;
17566:
17567: BEGIN
17568:
17569: -- Standard call to check for call compatibility.
17570: IF NOT FND_API.Compatible_API_Call (l_api_version,
17571: p_api_version,
17572: l_api_name,
17573: G_PKG_NAME )

Line 17672: -- Bug 7013954 Standard Start of API savepoint

17668: where vendor_type_lookup_code = 'EMPLOYEE'));
17669:
17670: COMMIT;
17671:
17672: -- Bug 7013954 Standard Start of API savepoint
17673: SAVEPOINT Import_Vendor_Contact_PUB;
17674:
17675: -- Cursor processing for vendor contact interface record
17676: OPEN contact_int_cur;

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

17766: -- End of API body.
17767:
17768: COMMIT WORK;
17769:
17770: -- Standard call to get message count and if count is 1,
17771: -- get message info.
17772: FND_MSG_PUB.Count_And_Get(
17773: p_count => x_msg_count,
17774: p_data => x_msg_data

Line 17847: -- Standard Start of API savepoint

17843: l_count NUMBER := 0;
17844: l_event_vendor_contact_id AP_SUPPLIER_CONTACTS.vendor_contact_id%TYPE; --Bug 7307669
17845: BEGIN
17846:
17847: -- Standard Start of API savepoint
17848: SAVEPOINT Update_Address_Assign_DFF_PUB;
17849:
17850: -- Standard call to check for call compatibility.
17851: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

Line 17850: -- Standard call to check for call compatibility.

17846:
17847: -- Standard Start of API savepoint
17848: SAVEPOINT Update_Address_Assign_DFF_PUB;
17849:
17850: -- Standard call to check for call compatibility.
17851: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
17852: p_api_version ,
17853: l_api_name ,
17854: G_PKG_NAME )

Line 17927: -- Standard check of p_commit.

17923: END; -- Bug 7307669 : End
17924:
17925: -- End of API body.
17926:
17927: -- Standard check of p_commit.
17928: IF FND_API.To_Boolean( p_commit ) THEN
17929: COMMIT WORK;
17930: END IF;
17931:

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

17928: IF FND_API.To_Boolean( p_commit ) THEN
17929: COMMIT WORK;
17930: END IF;
17931:
17932: -- Standard call to get message count and if count is 1,
17933: -- get message info.
17934: FND_MSG_PUB.Count_And_Get(
17935: p_count => x_msg_count ,
17936: p_data => x_msg_data