eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_DMEXTRACT_PVT dependencies on FND_API

Line 325: x_return_status := FND_API.g_ret_sts_error;

321: EXCEPTION
322: WHEN OTHERS THEN
323: ROLLBACK TO Insert_Drv_Stg_Upd;
324: -- kbasavar migrated chi's changes for 3089951
325: x_return_status := FND_API.g_ret_sts_error;
326:
327: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
328: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
329: END IF;

Line 2888: x_return_status := FND_API.g_ret_sts_success;

2884: BEGIN
2885: --------------------- initialize -----------------------
2886: SAVEPOINT Insert_Party_Details;
2887:
2888: x_return_status := FND_API.g_ret_sts_success;
2889:
2890: IF (AMS_DEBUG_HIGH_ON) THEN
2891: AMS_Utility_PVT.debug_message (l_full_name || ': Start');
2892: END IF;

Line 3207: RAISE FND_API.g_exc_error;

3203: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
3204: FND_MESSAGE.set_name ('AMS', 'AMS_API_RECORD_NOT_FOUND');
3205: FND_MSG_PUB.add;
3206: END IF;
3207: RAISE FND_API.g_exc_error;
3208: END IF;
3209: */
3210: -------------------- finish --------------------------
3211: COMMIT;

Line 3221: x_return_status := FND_API.g_ret_sts_error;

3217: EXCEPTION
3218: WHEN OTHERS THEN
3219: ROLLBACK TO Insert_Party_Details;
3220:
3221: x_return_status := FND_API.g_ret_sts_error;
3222:
3223: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3224: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
3225: END IF;

Line 3237: x_return_status := FND_API.g_ret_sts_success;

3233: BEGIN
3234: --------------------- initialize -----------------------
3235: SAVEPOINT Insert_Party_Details_Time;
3236:
3237: x_return_status := FND_API.g_ret_sts_success;
3238:
3239: IF (AMS_DEBUG_HIGH_ON) THEN
3240: AMS_Utility_PVT.debug_message (l_full_name || ': Start');
3241: END IF;

Line 3451: x_return_status := FND_API.g_ret_sts_error;

3447: EXCEPTION
3448: WHEN OTHERS THEN
3449: ROLLBACK TO Insert_Party_Details_Time;
3450:
3451: x_return_status := FND_API.g_ret_sts_error;
3452:
3453: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3454: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
3455: END IF;

Line 3681: RAISE FND_API.g_exc_unexpected_error;

3677: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3678: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
3679: END IF;
3680:
3681: RAISE FND_API.g_exc_unexpected_error;
3682:
3683: END UpdatePartyDetails;
3684: -- End of Updating Party Details
3685:

Line 3902: RAISE FND_API.g_exc_unexpected_error;

3898: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3899: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
3900: END IF;
3901:
3902: RAISE FND_API.g_exc_unexpected_error;
3903:
3904: END UpdatePartyDetailsTime;
3905: -- End of Updating Party Details Time
3906:

Line 3909: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

3905: -- End of Updating Party Details Time
3906:
3907: PROCEDURE ExtractMain (
3908: p_api_version IN NUMBER,
3909: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
3910: p_commit IN VARCHAR2 := FND_API.g_false,
3911:
3912: x_return_status OUT NOCOPY VARCHAR2,
3913: x_msg_count OUT NOCOPY NUMBER,

Line 3910: p_commit IN VARCHAR2 := FND_API.g_false,

3906:
3907: PROCEDURE ExtractMain (
3908: p_api_version IN NUMBER,
3909: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
3910: p_commit IN VARCHAR2 := FND_API.g_false,
3911:
3912: x_return_status OUT NOCOPY VARCHAR2,
3913: x_msg_count OUT NOCOPY NUMBER,
3914: x_msg_data OUT NOCOPY VARCHAR2,

Line 3970: IF FND_API.to_boolean (p_init_msg_list) THEN

3966: IF (AMS_DEBUG_HIGH_ON) THEN
3967: AMS_Utility_PVT.debug_message (l_full_name || ': Start');
3968: END IF;
3969:
3970: IF FND_API.to_boolean (p_init_msg_list) THEN
3971: FND_MSG_PUB.initialize;
3972: END IF;
3973:
3974: IF NOT FND_API.compatible_api_call(

Line 3974: IF NOT FND_API.compatible_api_call(

3970: IF FND_API.to_boolean (p_init_msg_list) THEN
3971: FND_MSG_PUB.initialize;
3972: END IF;
3973:
3974: IF NOT FND_API.compatible_api_call(
3975: l_api_version,
3976: p_api_version,
3977: l_api_name,
3978: g_pkg_name

Line 3980: RAISE FND_API.g_exc_unexpected_error;

3976: p_api_version,
3977: l_api_name,
3978: g_pkg_name
3979: ) THEN
3980: RAISE FND_API.g_exc_unexpected_error;
3981: END IF;
3982:
3983: x_return_status := FND_API.g_ret_sts_success;
3984:

Line 3983: x_return_status := FND_API.g_ret_sts_success;

3979: ) THEN
3980: RAISE FND_API.g_exc_unexpected_error;
3981: END IF;
3982:
3983: x_return_status := FND_API.g_ret_sts_success;
3984:
3985: -- truncate staging tables
3986: TruncateStgTables;
3987:

Line 4023: IF x_return_status <> FND_API.g_ret_sts_success THEN

4019: p_object_type => l_object_type,
4020: x_return_status => x_return_status
4021: );
4022:
4023: IF x_return_status <> FND_API.g_ret_sts_success THEN
4024: RAISE FND_API.g_exc_error;
4025: END IF;
4026:
4027: -- load into staging tables

Line 4024: RAISE FND_API.g_exc_error;

4020: x_return_status => x_return_status
4021: );
4022:
4023: IF x_return_status <> FND_API.g_ret_sts_success THEN
4024: RAISE FND_API.g_exc_error;
4025: END IF;
4026:
4027: -- load into staging tables
4028: InsertGenStg (

Line 4056: IF x_return_status <> FND_API.g_ret_sts_success THEN

4052:
4053: -- load into targets
4054: InsertPartyDetails(x_return_status);
4055:
4056: IF x_return_status <> FND_API.g_ret_sts_success THEN
4057: RAISE FND_API.g_exc_error;
4058: END IF;
4059:
4060: InsertPartyDetailsTime(x_return_status);

Line 4057: RAISE FND_API.g_exc_error;

4053: -- load into targets
4054: InsertPartyDetails(x_return_status);
4055:
4056: IF x_return_status <> FND_API.g_ret_sts_success THEN
4057: RAISE FND_API.g_exc_error;
4058: END IF;
4059:
4060: InsertPartyDetailsTime(x_return_status);
4061:

Line 4062: IF x_return_status <> FND_API.g_ret_sts_success THEN

4058: END IF;
4059:
4060: InsertPartyDetailsTime(x_return_status);
4061:
4062: IF x_return_status <> FND_API.g_ret_sts_success THEN
4063: -- kbasavar migrated chi's changes for bug 3089951
4064: sync_party_tables;
4065: RAISE FND_API.g_exc_error;
4066: END IF;

Line 4065: RAISE FND_API.g_exc_error;

4061:
4062: IF x_return_status <> FND_API.g_ret_sts_success THEN
4063: -- kbasavar migrated chi's changes for bug 3089951
4064: sync_party_tables;
4065: RAISE FND_API.g_exc_error;
4066: END IF;
4067:
4068: /*
4069: The extraction process is driven by various criteria like if its a B2B model or is it a customer profitability etc.

Line 4108: IF x_return_status <> FND_API.g_ret_sts_success THEN

4104: p_party_type => l_party_type,
4105: x_return_status => x_return_status
4106: );
4107:
4108: IF x_return_status <> FND_API.g_ret_sts_success THEN
4109: RAISE FND_API.g_exc_error;
4110: END IF;
4111:
4112: -- insert into staging tables

Line 4109: RAISE FND_API.g_exc_error;

4105: x_return_status => x_return_status
4106: );
4107:
4108: IF x_return_status <> FND_API.g_ret_sts_success THEN
4109: RAISE FND_API.g_exc_error;
4110: END IF;
4111:
4112: -- insert into staging tables
4113: InsertGenStg (

Line 4152: IF FND_API.to_boolean (p_commit) THEN

4148:
4149: -- analyze_mining_tables;
4150:
4151: -------------------- finish --------------------------
4152: IF FND_API.to_boolean (p_commit) THEN
4153: COMMIT;
4154: END IF;
4155:
4156: FND_MSG_PUB.count_and_get (

Line 4157: p_encoded => FND_API.g_false,

4153: COMMIT;
4154: END IF;
4155:
4156: FND_MSG_PUB.count_and_get (
4157: p_encoded => FND_API.g_false,
4158: p_count => x_msg_count,
4159: p_data => x_msg_data
4160: );
4161:

Line 4167: WHEN FND_API.g_exc_error THEN

4163: AMS_Utility_PVT.debug_message (l_full_name || ': End');
4164: END IF;
4165:
4166: EXCEPTION
4167: WHEN FND_API.g_exc_error THEN
4168: ROLLBACK TO Extract_Main;
4169: x_return_status := FND_API.g_ret_sts_error;
4170: FND_MSG_PUB.count_and_get (
4171: p_encoded => FND_API.g_false,

Line 4169: x_return_status := FND_API.g_ret_sts_error;

4165:
4166: EXCEPTION
4167: WHEN FND_API.g_exc_error THEN
4168: ROLLBACK TO Extract_Main;
4169: x_return_status := FND_API.g_ret_sts_error;
4170: FND_MSG_PUB.count_and_get (
4171: p_encoded => FND_API.g_false,
4172: p_count => x_msg_count,
4173: p_data => x_msg_data

Line 4171: p_encoded => FND_API.g_false,

4167: WHEN FND_API.g_exc_error THEN
4168: ROLLBACK TO Extract_Main;
4169: x_return_status := FND_API.g_ret_sts_error;
4170: FND_MSG_PUB.count_and_get (
4171: p_encoded => FND_API.g_false,
4172: p_count => x_msg_count,
4173: p_data => x_msg_data
4174: );
4175: WHEN FND_API.g_exc_unexpected_error THEN

Line 4175: WHEN FND_API.g_exc_unexpected_error THEN

4171: p_encoded => FND_API.g_false,
4172: p_count => x_msg_count,
4173: p_data => x_msg_data
4174: );
4175: WHEN FND_API.g_exc_unexpected_error THEN
4176: ROLLBACK TO Extract_Main;
4177: x_return_status := FND_API.g_ret_sts_unexp_error ;
4178: FND_MSG_PUB.count_and_get (
4179: p_encoded => FND_API.g_false,

Line 4177: x_return_status := FND_API.g_ret_sts_unexp_error ;

4173: p_data => x_msg_data
4174: );
4175: WHEN FND_API.g_exc_unexpected_error THEN
4176: ROLLBACK TO Extract_Main;
4177: x_return_status := FND_API.g_ret_sts_unexp_error ;
4178: FND_MSG_PUB.count_and_get (
4179: p_encoded => FND_API.g_false,
4180: p_count => x_msg_count,
4181: p_data => x_msg_data

Line 4179: p_encoded => FND_API.g_false,

4175: WHEN FND_API.g_exc_unexpected_error THEN
4176: ROLLBACK TO Extract_Main;
4177: x_return_status := FND_API.g_ret_sts_unexp_error ;
4178: FND_MSG_PUB.count_and_get (
4179: p_encoded => FND_API.g_false,
4180: p_count => x_msg_count,
4181: p_data => x_msg_data
4182: );
4183: WHEN OTHERS THEN

Line 4185: x_return_status := FND_API.g_ret_sts_unexp_error ;

4181: p_data => x_msg_data
4182: );
4183: WHEN OTHERS THEN
4184: ROLLBACK TO Extract_Main;
4185: x_return_status := FND_API.g_ret_sts_unexp_error ;
4186:
4187: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error)
4188: THEN
4189: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

Line 4193: p_encoded => FND_API.g_false,

4189: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
4190: END IF;
4191:
4192: FND_MSG_PUB.count_and_get (
4193: p_encoded => FND_API.g_false,
4194: p_count => x_msg_count,
4195: p_data => x_msg_data
4196: );
4197: END ExtractMain;

Line 4217: p_init_msg_list => FND_API.G_TRUE,

4213: retcode := 0;
4214:
4215: ExtractMain (
4216: p_api_version => 1.0,
4217: p_init_msg_list => FND_API.G_TRUE,
4218: p_commit => FND_API.G_TRUE,
4219:
4220: x_return_status => l_return_status,
4221: x_msg_count => l_msg_count,

Line 4218: p_commit => FND_API.G_TRUE,

4214:
4215: ExtractMain (
4216: p_api_version => 1.0,
4217: p_init_msg_list => FND_API.G_TRUE,
4218: p_commit => FND_API.G_TRUE,
4219:
4220: x_return_status => l_return_status,
4221: x_msg_count => l_msg_count,
4222: x_msg_data => l_msg_data,

Line 4225: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4221: x_msg_count => l_msg_count,
4222: x_msg_data => l_msg_data,
4223: p_mode => G_MODE_UPDATE
4224: );
4225: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4226: FOR i IN 1 .. l_msg_count LOOP
4227: AMS_Utility_PVT.create_log (
4228: x_return_status => l_return_status,
4229: p_arc_log_used_by => 'MODL',

Line 4231: p_msg_data => FND_MSG_PUB.get(i, FND_API.g_false),

4227: AMS_Utility_PVT.create_log (
4228: x_return_status => l_return_status,
4229: p_arc_log_used_by => 'MODL',
4230: p_log_used_by_id => -1, -- party update is for all of party details, so no specific id
4231: p_msg_data => FND_MSG_PUB.get(i, FND_API.g_false),
4232: p_msg_type => 'ERROR'
4233: );
4234: END LOOP;
4235: retcode := 2;