DBA Data[Home] [Help]

APPS.AP_VENDOR_PUB_PKG dependencies on STANDARD

Line 3055: -- Standard Start of API savepoint

3051: l_party_usg_validation_level NUMBER;
3052: l_debug_info VARCHAR2(500); -- Bug 6823885
3053:
3054: BEGIN
3055: -- Standard Start of API savepoint
3056: SAVEPOINT Create_Vendor_PUB;
3057:
3058: -- Standard call to check for call compatibility.
3059: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

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

3054: BEGIN
3055: -- Standard Start of API savepoint
3056: SAVEPOINT Create_Vendor_PUB;
3057:
3058: -- Standard call to check for call compatibility.
3059: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
3060: p_api_version ,
3061: l_api_name ,
3062: G_PKG_NAME )

Line 3469: -- Standard check of p_commit.

3465: END IF; --Supplier Valid
3466:
3467: -- End of API body.
3468:
3469: -- Standard check of p_commit.
3470: IF FND_API.To_Boolean( p_commit ) THEN
3471: COMMIT WORK;
3472: END IF;
3473:

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

3470: IF FND_API.To_Boolean( p_commit ) THEN
3471: COMMIT WORK;
3472: END IF;
3473:
3474: -- Standard call to get message count and if count is 1,
3475: -- get message info.
3476: FND_MSG_PUB.Count_And_Get(
3477: p_count => x_msg_count ,
3478: p_data => x_msg_data

Line 3552: -- Standard Start of API savepoint

3548: l_org_party_id NUMBER;
3549:
3550:
3551: BEGIN
3552: -- Standard Start of API savepoint
3553: SAVEPOINT Update_Vendor_PUB;
3554:
3555: -- Standard call to check for call compatibility.
3556: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

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

3551: BEGIN
3552: -- Standard Start of API savepoint
3553: SAVEPOINT Update_Vendor_PUB;
3554:
3555: -- Standard call to check for call compatibility.
3556: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
3557: p_api_version ,
3558: l_api_name ,
3559: G_PKG_NAME )

Line 4155: -- Standard check of p_commit.

4151: END IF;
4152:
4153: -- End of API body.
4154:
4155: -- Standard check of p_commit.
4156: IF FND_API.To_Boolean( p_commit ) THEN
4157: COMMIT WORK;
4158: END IF;
4159:

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

4156: IF FND_API.To_Boolean( p_commit ) THEN
4157: COMMIT WORK;
4158: END IF;
4159:
4160: -- Standard call to get message count and if count is 1,
4161: -- get message info.
4162: FND_MSG_PUB.Count_And_Get(
4163: p_count => x_msg_count ,
4164: p_data => x_msg_data

Line 4230: -- Standard Start of API savepoint

4226: l_default_country_code VARCHAR2(25); --bug6050423
4227:
4228:
4229: BEGIN
4230: -- Standard Start of API savepoint
4231: SAVEPOINT Validate_Vendor_PUB;
4232:
4233: -- Standard call to check for call compatibility.
4234: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

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

4229: BEGIN
4230: -- Standard Start of API savepoint
4231: SAVEPOINT Validate_Vendor_PUB;
4232:
4233: -- Standard call to check for call compatibility.
4234: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
4235: p_api_version ,
4236: l_api_name ,
4237: G_PKG_NAME )

Line 6817: -- Standard check of p_commit.

6813: END IF; --p_mode
6814:
6815: -- End of API body
6816:
6817: -- Standard check of p_commit.
6818: IF FND_API.To_Boolean( p_commit ) THEN
6819: COMMIT WORK;
6820: END IF;
6821:

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

6818: IF FND_API.To_Boolean( p_commit ) THEN
6819: COMMIT WORK;
6820: END IF;
6821:
6822: -- Standard call to get message count and if count is 1,
6823: -- get message info.
6824: FND_MSG_PUB.Count_And_Get(
6825: p_count => x_msg_count ,
6826: p_data => x_msg_data

Line 7069: -- Standard Start of API savepoint

7065:
7066:
7067:
7068: BEGIN
7069: -- Standard Start of API savepoint
7070: SAVEPOINT Create_Vendor_Site_PUB;
7071:
7072: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
7073: p_api_version ,

Line 7903: -- Standard check of p_commit.

7899: END IF;
7900:
7901: -- End of API body.
7902:
7903: -- Standard check of p_commit.
7904: IF FND_API.To_Boolean( p_commit ) THEN
7905: COMMIT WORK;
7906: END IF;
7907:

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

7904: IF FND_API.To_Boolean( p_commit ) THEN
7905: COMMIT WORK;
7906: END IF;
7907:
7908: -- Standard call to get message count and if count is 1,
7909: -- get message info.
7910: FND_MSG_PUB.Count_And_Get(
7911: p_count => x_msg_count ,
7912: p_data => x_msg_data

Line 7995: -- Standard Start of API savepoint

7991:
7992:
7993:
7994: BEGIN
7995: -- Standard Start of API savepoint
7996: SAVEPOINT Update_Vendor_Site_PUB;
7997:
7998: -- Standard call to check for call compatibility.
7999: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

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

7994: BEGIN
7995: -- Standard Start of API savepoint
7996: SAVEPOINT Update_Vendor_Site_PUB;
7997:
7998: -- Standard call to check for call compatibility.
7999: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
8000: p_api_version ,
8001: l_api_name ,
8002: G_PKG_NAME )

Line 8598: -- Standard check of p_commit.

8594: END IF;
8595:
8596: -- End of API body.
8597:
8598: -- Standard check of p_commit.
8599: IF FND_API.To_Boolean( p_commit ) THEN
8600: COMMIT WORK;
8601: END IF;
8602:

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

8599: IF FND_API.To_Boolean( p_commit ) THEN
8600: COMMIT WORK;
8601: END IF;
8602:
8603: -- Standard call to get message count and if count is 1,
8604: -- get message info.
8605: FND_MSG_PUB.Count_And_Get(
8606: p_count => x_msg_count ,
8607: p_data => x_msg_data

Line 8682: -- Standard Start of API savepoint

8678: BEGIN
8679:
8680: l_tolerance_type := 'QUANTITY';
8681:
8682: -- Standard Start of API savepoint
8683: SAVEPOINT Validate_Vendor_Site_PUB;
8684:
8685: -- Standard call to check for call compatibility.
8686: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

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

8681:
8682: -- Standard Start of API savepoint
8683: SAVEPOINT Validate_Vendor_Site_PUB;
8684:
8685: -- Standard call to check for call compatibility.
8686: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
8687: p_api_version ,
8688: l_api_name ,
8689: G_PKG_NAME )

Line 11335: -- Standard check of p_commit.

11331: END IF; --p_mode
11332:
11333: -- End of API body.
11334:
11335: -- Standard check of p_commit.
11336: IF FND_API.To_Boolean( p_commit ) THEN
11337: COMMIT WORK;
11338: END IF;
11339:

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

11336: IF FND_API.To_Boolean( p_commit ) THEN
11337: COMMIT WORK;
11338: END IF;
11339:
11340: -- Standard call to get message count and if count is 1,
11341: -- get message info.
11342: FND_MSG_PUB.Count_And_Get(
11343: p_count => x_msg_count ,
11344: p_data => x_msg_data

Line 11480: -- Standard Start of API savepoint

11476: l_debug_info VARCHAR2(500); -- Bug 6823885
11477: l_party_site_num VARCHAR2(1); -- Bug 6823885
11478:
11479: BEGIN
11480: -- Standard Start of API savepoint
11481: SAVEPOINT Create_Vendor_Contact_PUB;
11482:
11483: -- Standard call to check for call compatibility.
11484: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

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

11479: BEGIN
11480: -- Standard Start of API savepoint
11481: SAVEPOINT Create_Vendor_Contact_PUB;
11482:
11483: -- Standard call to check for call compatibility.
11484: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
11485: p_api_version ,
11486: l_api_name ,
11487: G_PKG_NAME )

Line 12024: -- Standard check of p_commit.

12020: END IF;
12021:
12022: -- End of API body.
12023:
12024: -- Standard check of p_commit.
12025: IF FND_API.To_Boolean( p_commit ) THEN
12026: COMMIT WORK;
12027: END IF;
12028:

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

12025: IF FND_API.To_Boolean( p_commit ) THEN
12026: COMMIT WORK;
12027: END IF;
12028:
12029: -- Standard call to get message count and if count is 1,
12030: -- get message info.
12031: FND_MSG_PUB.Count_And_Get(
12032: p_count => x_msg_count ,
12033: p_data => x_msg_data

Line 12083: -- Standard Start of API savepoint

12079: l_api_name CONSTANT VARCHAR2(30) := 'Update_Vendor_Contact';
12080: l_api_version CONSTANT NUMBER := 1.0;
12081:
12082: BEGIN
12083: -- Standard Start of API savepoint
12084: SAVEPOINT Update_Vendor_Contact_PUB;
12085:
12086: -- Standard call to check for call compatibility.
12087: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

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

12082: BEGIN
12083: -- Standard Start of API savepoint
12084: SAVEPOINT Update_Vendor_Contact_PUB;
12085:
12086: -- Standard call to check for call compatibility.
12087: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
12088: p_api_version ,
12089: l_api_name ,
12090: G_PKG_NAME )

Line 12134: -- Standard check of p_commit.

12130: END IF;
12131:
12132: -- End of API body.
12133:
12134: -- Standard check of p_commit.
12135: IF FND_API.To_Boolean( p_commit ) THEN
12136: COMMIT WORK;
12137: END IF;
12138:

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

12135: IF FND_API.To_Boolean( p_commit ) THEN
12136: COMMIT WORK;
12137: END IF;
12138:
12139: -- Standard call to get message count and if count is 1,
12140: -- get message info.
12141: FND_MSG_PUB.Count_And_Get(
12142: p_count => x_msg_count ,
12143: p_data => x_msg_data

Line 12201: -- Standard Start of API savepoint

12197: BEGIN
12198: -- Bug 7013954 The validation logic is modified to accomodate the changes
12199: -- related to contacts. The Contacts are now associated at Party Site/Address
12200: -- or at Supplier level. Supplier Site level association is deprecated in R12.
12201: -- Standard Start of API savepoint
12202: SAVEPOINT Validate_Vendor_Contact_PUB;
12203:
12204: -- Standard call to check for call compatibility.
12205: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

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

12200: -- or at Supplier level. Supplier Site level association is deprecated in R12.
12201: -- Standard Start of API savepoint
12202: SAVEPOINT Validate_Vendor_Contact_PUB;
12203:
12204: -- Standard call to check for call compatibility.
12205: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
12206: p_api_version ,
12207: l_api_name ,
12208: G_PKG_NAME )

Line 12651: -- Standard check of p_commit.

12647: x_org_contact_valid := 'N';
12648: END IF;
12649: -- End of API body.
12650:
12651: -- Standard check of p_commit.
12652: IF FND_API.To_Boolean( p_commit ) THEN
12653: COMMIT WORK;
12654: END IF;
12655:

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

12652: IF FND_API.To_Boolean( p_commit ) THEN
12653: COMMIT WORK;
12654: END IF;
12655:
12656: -- Standard call to get message count and if count is 1,
12657: -- get message info.
12658: FND_MSG_PUB.Count_And_Get(
12659: p_count => x_msg_count ,
12660: p_data => x_msg_data

Line 12754: -- Standard Start of API savepoint

12750: l_debug_info varchar2(500); -- Bug 6823885
12751:
12752: BEGIN
12753:
12754: -- Standard Start of API savepoint
12755: SAVEPOINT Import_Vendor_PUB;
12756:
12757: -- Standard call to check for call compatibility.
12758: IF NOT FND_API.Compatible_API_Call (l_api_version,

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

12753:
12754: -- Standard Start of API savepoint
12755: SAVEPOINT Import_Vendor_PUB;
12756:
12757: -- Standard call to check for call compatibility.
12758: IF NOT FND_API.Compatible_API_Call (l_api_version,
12759: p_api_version,
12760: l_api_name,
12761: G_PKG_NAME )

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

12842: vendor_rec.end_date_active := vendor_int_rec.end_date_active;
12843: vendor_rec.minority_group_lookup_code := vendor_int_rec.minority_group_lookup_code;
12844: vendor_rec.women_owned_flag := vendor_int_rec.women_owned_flag;
12845: vendor_rec.small_business_flag := vendor_int_rec.small_business_flag;
12846: vendor_rec.SIC_Code := vendor_int_rec.standard_industry_class;
12847: vendor_rec.hold_flag := vendor_int_rec.hold_flag;
12848: vendor_rec.purchasing_hold_reason := vendor_int_rec.purchasing_hold_reason;
12849: vendor_rec.hold_by := vendor_int_rec.hold_by;
12850: vendor_rec.hold_date := vendor_int_rec.hold_date;

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

13217: -- End of API body.
13218:
13219: COMMIT WORK;
13220:
13221: -- Standard call to get message count and if count is 1,
13222: -- get message info.
13223: FND_MSG_PUB.Count_And_Get(
13224: p_count => x_msg_count,
13225: p_data => x_msg_data

Line 13321: -- Standard Start of API savepoint

13317: l_debug_info varchar2(500); -- Bug 6823885
13318:
13319: BEGIN
13320:
13321: -- Standard Start of API savepoint
13322: SAVEPOINT Import_Vendor_Sites_PUB;
13323:
13324: -- Standard call to check for call compatibility.
13325: IF NOT FND_API.Compatible_API_Call (l_api_version,

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

13320:
13321: -- Standard Start of API savepoint
13322: SAVEPOINT Import_Vendor_Sites_PUB;
13323:
13324: -- Standard call to check for call compatibility.
13325: IF NOT FND_API.Compatible_API_Call (l_api_version,
13326: p_api_version,
13327: l_api_name,
13328: G_PKG_NAME )

Line 13850: -- Standard check of p_commit.

13846:
13847: END IF;
13848: -- End of API body.
13849:
13850: -- Standard check of p_commit.
13851: COMMIT WORK;
13852:
13853: -- Standard call to get message count and if count is 1,
13854: -- get message info.

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

13849:
13850: -- Standard check of p_commit.
13851: COMMIT WORK;
13852:
13853: -- Standard call to get message count and if count is 1,
13854: -- get message info.
13855: FND_MSG_PUB.Count_And_Get(
13856: p_count => x_msg_count,
13857: p_data => x_msg_data

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

13935: vendor_contact_rec r_vendor_contact_rec_type;
13936:
13937: BEGIN
13938:
13939: -- Standard call to check for call compatibility.
13940: IF NOT FND_API.Compatible_API_Call (l_api_version,
13941: p_api_version,
13942: l_api_name,
13943: G_PKG_NAME )

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

14035: where vendor_type_lookup_code = 'EMPLOYEE'));
14036:
14037: COMMIT;
14038:
14039: -- Bug 7013954 Standard Start of API savepoint
14040: SAVEPOINT Import_Vendor_Contact_PUB;
14041:
14042: -- Cursor processing for vendor contact interface record
14043: OPEN contact_int_cur;

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

14133: -- End of API body.
14134:
14135: COMMIT WORK;
14136:
14137: -- Standard call to get message count and if count is 1,
14138: -- get message info.
14139: FND_MSG_PUB.Count_And_Get(
14140: p_count => x_msg_count,
14141: p_data => x_msg_data

Line 14214: -- Standard Start of API savepoint

14210: l_count NUMBER := 0;
14211: l_event_vendor_contact_id AP_SUPPLIER_CONTACTS.vendor_contact_id%TYPE; --Bug 7307669
14212: BEGIN
14213:
14214: -- Standard Start of API savepoint
14215: SAVEPOINT Update_Address_Assign_DFF_PUB;
14216:
14217: -- Standard call to check for call compatibility.
14218: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

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

14213:
14214: -- Standard Start of API savepoint
14215: SAVEPOINT Update_Address_Assign_DFF_PUB;
14216:
14217: -- Standard call to check for call compatibility.
14218: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
14219: p_api_version ,
14220: l_api_name ,
14221: G_PKG_NAME )

Line 14294: -- Standard check of p_commit.

14290: END; -- Bug 7307669 : End
14291:
14292: -- End of API body.
14293:
14294: -- Standard check of p_commit.
14295: IF FND_API.To_Boolean( p_commit ) THEN
14296: COMMIT WORK;
14297: END IF;
14298:

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

14295: IF FND_API.To_Boolean( p_commit ) THEN
14296: COMMIT WORK;
14297: END IF;
14298:
14299: -- Standard call to get message count and if count is 1,
14300: -- get message info.
14301: FND_MSG_PUB.Count_And_Get(
14302: p_count => x_msg_count ,
14303: p_data => x_msg_data