62: l_msg_index_out number;
63: Begin
64:
65: if p_error_type in ('EXP','UNEXP','OTHER') then
66: G_MESG_COUNT := FND_MSG_PUB.Count_Msg;
67: write_log(3, 'Message Count:'||G_MESG_COUNT);
68: For i IN 1..G_MESG_COUNT Loop
69: FND_MSG_PUB.Get(
70: p_msg_index => i,
65: if p_error_type in ('EXP','UNEXP','OTHER') then
66: G_MESG_COUNT := FND_MSG_PUB.Count_Msg;
67: write_log(3, 'Message Count:'||G_MESG_COUNT);
68: For i IN 1..G_MESG_COUNT Loop
69: FND_MSG_PUB.Get(
70: p_msg_index => i,
71: p_encoded => FND_API.G_FALSE,
72: p_data => l_msg_data,
73: p_msg_index_out =>l_msg_index_out
2423: CLOSE c_get_source_code;
2424:
2425: -- ffang 052301, push error message into stack
2426: AS_UTILITY_PVT.Set_Message(
2427: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
2428: p_msg_name => 'API_INVALID_ID',
2429: p_token1 => 'COLUMN',
2430: p_token1_value => 'PROMOTION ID',
2431: p_token2 => 'VALUE',
2447: write_log(3,'promotion_id: '||pI.promotion_id);
2448: write_log(3,'promotion_code: '||pI.promotion_code);
2449:
2450: AS_UTILITY_PVT.Set_Message(
2451: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
2452: p_msg_name => 'AS_NOT_MATCHING_ID_CODE',
2453: p_token1 => 'VALUE1',
2454: p_token1_value => pI.promotion_id,
2455: p_token2 => 'VALUE2',
2477: CLOSE c_get_promotion_id;
2478:
2479: -- ffang 052301, push error message into stack
2480: AS_UTILITY_PVT.Set_Message(
2481: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
2482: p_msg_name => 'API_INVALID_ID',
2483: p_token1 => 'COLUMN',
2484: p_token1_value => 'PROMOTION CODE',
2485: p_token2 => 'VALUE',
3699: l_rule_id := to_number(FND_PROFILE.value('AS_USE_DQM_RULE_CODE_PERSON'));
3700: ELSE
3701: --else bad party_type
3702: AS_UTILITY_PVT.Set_Message(
3703: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
3704: p_msg_name => 'AS_INVALID_PARTY_TYPE',
3705: p_token1 => 'VALUE',
3706: p_token1_value => I.party_type);
3707: write_log (3, 'Party_type is invalid');
4216: -- For each lead
4217: For I in c_main(p_parent_request_id, p_child_request_id)
4218: Loop
4219: l_batch_size := l_batch_size +1;
4220: FND_MSG_PUB.Initialize;
4221:
4222: Begin
4223:
4224: IF I.party_type IS NULL THEN
4232: write_log(3, 'Processing import_interface_id: '||to_char(I.import_interface_id));
4233:
4234: IF l_source_system < 1 THEN
4235: AS_UTILITY_PVT.Set_Message(
4236: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
4237: p_msg_name => 'API_INVALID_ID',
4238: p_token1 => 'COLUMN',
4239: p_token1_value => 'SOURCE_SYSTEM',
4240: p_token2 => 'VALUE',
4246: IF I.currency_code IS NULL AND I.budget_amount IS NOT NULL THEN
4247: -- SOLIN, Bug 4956232
4248: -- throw exception, not get currency_code for not null budget_amount
4249: AS_UTILITY_PVT.Set_Message(
4250: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
4251: p_msg_name => 'API_INVALID_ID',
4252: p_token1 => 'COLUMN',
4253: p_token1_value => 'CURRENCY_CODE',
4254: p_token2 => 'VALUE',
4378: I.new_party_flag := 1; --new party flag set
4379: ELSE
4380: -- ffang 101201, bug2050535, push error message
4381: AS_UTILITY_PVT.Set_Message(
4382: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
4383: p_msg_name => 'AS_INVALID_PARTY_TYPE',
4384: p_token1 => 'VALUE',
4385: p_token1_value => I.party_type);
4386: write_log (3, 'Party_type is invalid');