321: IF FND_GLOBAL.User_Id IS NULL
322: THEN
323: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
324: THEN
325: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
326: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
327: FND_MSG_PUB.ADD;
328: END IF;
329: RAISE FND_API.G_EXC_ERROR;
322: THEN
323: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
324: THEN
325: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
326: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
327: FND_MSG_PUB.ADD;
328: END IF;
329: RAISE FND_API.G_EXC_ERROR;
330: END IF;
380: END IF;
381:
382: IF (l_update_access_flag <> 'Y') THEN
383: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
384: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');
385: FND_MESSAGE.Set_Token('INFO', 'CUSTOMER_ID,OPPORTUNITY_ID,SALESFORCE_ID', FALSE);
386: FND_MSG_PUB.ADD;
387: END IF;
388: RAISE FND_API.G_EXC_ERROR;
381:
382: IF (l_update_access_flag <> 'Y') THEN
383: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
384: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');
385: FND_MESSAGE.Set_Token('INFO', 'CUSTOMER_ID,OPPORTUNITY_ID,SALESFORCE_ID', FALSE);
386: FND_MSG_PUB.ADD;
387: END IF;
388: RAISE FND_API.G_EXC_ERROR;
389: END IF;
414: -- Progress Message
415: --
416: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
417: THEN
418: --FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
419: --FND_MESSAGE.Set_Token ('ROW', 'AS_OPP_SALES_CREDIT', TRUE);
420: --FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(I), FALSE);
421: --FND_MSG_PUB.Add;
422: IF l_debug THEN
415: --
416: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
417: THEN
418: --FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
419: --FND_MESSAGE.Set_Token ('ROW', 'AS_OPP_SALES_CREDIT', TRUE);
420: --FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(I), FALSE);
421: --FND_MSG_PUB.Add;
422: IF l_debug THEN
423: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
416: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
417: THEN
418: --FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
419: --FND_MESSAGE.Set_Token ('ROW', 'AS_OPP_SALES_CREDIT', TRUE);
420: --FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(I), FALSE);
421: --FND_MSG_PUB.Add;
422: IF l_debug THEN
423: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
424: 'Processing AS_OPP_SALES_CREDIT row number '||to_char(I));
1056: END IF;
1057:
1058: IF (l_update_access_flag <> 'Y') THEN
1059: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1060: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');
1061: FND_MESSAGE.Set_Token('INFO', 'CUSTOMER_ID,OPPORTUNITY_ID,SALESFORCE_ID', FALSE);
1062: FND_MSG_PUB.ADD;
1063: END IF;
1064: RAISE FND_API.G_EXC_ERROR;
1057:
1058: IF (l_update_access_flag <> 'Y') THEN
1059: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1060: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');
1061: FND_MESSAGE.Set_Token('INFO', 'CUSTOMER_ID,OPPORTUNITY_ID,SALESFORCE_ID', FALSE);
1062: FND_MSG_PUB.ADD;
1063: END IF;
1064: RAISE FND_API.G_EXC_ERROR;
1065: END IF;
1093:
1094:
1095: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1096: THEN
1097: --FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
1098: --FND_MESSAGE.Set_Token ('ROW', 'AS_OPP_SALES_CREDIT', TRUE);
1099: --FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(I), FALSE);
1100: --FND_MSG_PUB.Add;
1101: IF l_debug THEN
1094:
1095: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1096: THEN
1097: --FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
1098: --FND_MESSAGE.Set_Token ('ROW', 'AS_OPP_SALES_CREDIT', TRUE);
1099: --FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(I), FALSE);
1100: --FND_MSG_PUB.Add;
1101: IF l_debug THEN
1102: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1095: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1096: THEN
1097: --FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
1098: --FND_MESSAGE.Set_Token ('ROW', 'AS_OPP_SALES_CREDIT', TRUE);
1099: --FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(I), FALSE);
1100: --FND_MSG_PUB.Add;
1101: IF l_debug THEN
1102: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1103: 'Processing AS_OPP_SALES_CREDIT row number '||to_char(I));
1174: END IF;
1175:
1176: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1177: THEN
1178: FND_MESSAGE.Set_Name('AS', 'API_MISSING_UPDATE_TARGET');
1179: FND_MESSAGE.Set_Token ('INFO', 'sales_credit', FALSE);
1180: FND_MSG_PUB.Add;
1181: END IF;
1182: raise FND_API.G_EXC_ERROR;
1175:
1176: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1177: THEN
1178: FND_MESSAGE.Set_Name('AS', 'API_MISSING_UPDATE_TARGET');
1179: FND_MESSAGE.Set_Token ('INFO', 'sales_credit', FALSE);
1180: FND_MSG_PUB.Add;
1181: END IF;
1182: raise FND_API.G_EXC_ERROR;
1183: END IF;
1190: If (l_tar_SALES_CREDIT_rec.last_update_date is NULL or
1191: l_tar_SALES_CREDIT_rec.last_update_date = FND_API.G_MISS_Date ) Then
1192: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1193: THEN
1194: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
1195: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
1196: FND_MSG_PUB.ADD;
1197: END IF;
1198: raise FND_API.G_EXC_ERROR;
1191: l_tar_SALES_CREDIT_rec.last_update_date = FND_API.G_MISS_Date ) Then
1192: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1193: THEN
1194: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
1195: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
1196: FND_MSG_PUB.ADD;
1197: END IF;
1198: raise FND_API.G_EXC_ERROR;
1199: End if;
1200: -- Check Whether record has been changed by someone else
1201: If (l_tar_SALES_CREDIT_rec.last_update_date <> l_ref_SALES_CREDIT_rec.last_update_date) Then
1202: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1203: THEN
1204: FND_MESSAGE.Set_Name('AS', 'API_RECORD_CHANGED');
1205: FND_MESSAGE.Set_Token('INFO', 'sales_credit', FALSE);
1206: FND_MSG_PUB.ADD;
1207: END IF;
1208: raise FND_API.G_EXC_ERROR;
1201: If (l_tar_SALES_CREDIT_rec.last_update_date <> l_ref_SALES_CREDIT_rec.last_update_date) Then
1202: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1203: THEN
1204: FND_MESSAGE.Set_Name('AS', 'API_RECORD_CHANGED');
1205: FND_MESSAGE.Set_Token('INFO', 'sales_credit', FALSE);
1206: FND_MSG_PUB.ADD;
1207: END IF;
1208: raise FND_API.G_EXC_ERROR;
1209: End if;
1814: END IF;
1815:
1816: IF (l_update_access_flag <> 'Y') THEN
1817: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1818: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');
1819: FND_MESSAGE.Set_Token('INFO', 'CUSTOMER_ID,OPPORTUNITY_ID,SALESFORCE_ID', FALSE);
1820: FND_MSG_PUB.ADD;
1821: END IF;
1822: RAISE FND_API.G_EXC_ERROR;
1815:
1816: IF (l_update_access_flag <> 'Y') THEN
1817: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1818: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');
1819: FND_MESSAGE.Set_Token('INFO', 'CUSTOMER_ID,OPPORTUNITY_ID,SALESFORCE_ID', FALSE);
1820: FND_MSG_PUB.ADD;
1821: END IF;
1822: RAISE FND_API.G_EXC_ERROR;
1823: END IF;
2341: END IF;
2342:
2343: IF (l_update_access_flag <> 'Y') THEN
2344: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2345: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');
2346: FND_MESSAGE.Set_Token('INFO', 'CUSTOMER_ID,OPPORTUNITY_ID,SALESFORCE_ID', FALSE);
2347: FND_MSG_PUB.ADD;
2348: END IF;
2349: RAISE FND_API.G_EXC_ERROR;
2342:
2343: IF (l_update_access_flag <> 'Y') THEN
2344: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2345: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');
2346: FND_MESSAGE.Set_Token('INFO', 'CUSTOMER_ID,OPPORTUNITY_ID,SALESFORCE_ID', FALSE);
2347: FND_MSG_PUB.ADD;
2348: END IF;
2349: RAISE FND_API.G_EXC_ERROR;
2350: END IF;
2374: -- Progress Message
2375: --
2376: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2377: THEN
2378: --FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
2379: --FND_MESSAGE.Set_Token ('ROW', 'AS_OPP_SALES_CREDIT', TRUE);
2380: --FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(I), FALSE);
2381: --FND_MSG_PUB.Add;
2382: IF l_debug THEN
2375: --
2376: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2377: THEN
2378: --FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
2379: --FND_MESSAGE.Set_Token ('ROW', 'AS_OPP_SALES_CREDIT', TRUE);
2380: --FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(I), FALSE);
2381: --FND_MSG_PUB.Add;
2382: IF l_debug THEN
2383: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2376: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2377: THEN
2378: --FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
2379: --FND_MESSAGE.Set_Token ('ROW', 'AS_OPP_SALES_CREDIT', TRUE);
2380: --FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(I), FALSE);
2381: --FND_MSG_PUB.Add;
2382: IF l_debug THEN
2383: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2384: 'Processing AS_OPP_SALES_CREDIT row number '||to_char(I));
3163: IF p_sales_credit_rec.salesforce_id is NULL
3164: THEN
3165: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3166: THEN
3167: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
3168: FND_MESSAGE.Set_Token('COLUMN', 'TRANS_SALESFORCE', TRUE);
3169: FND_MSG_PUB.ADD;
3170: END IF;
3171:
3164: THEN
3165: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3166: THEN
3167: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
3168: FND_MESSAGE.Set_Token('COLUMN', 'TRANS_SALESFORCE', TRUE);
3169: FND_MSG_PUB.ADD;
3170: END IF;
3171:
3172: IF l_debug THEN
3188:
3189: THEN
3190: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3191: THEN
3192: FND_MESSAGE.Set_Name('AS', 'API_MEMBER_TOO_MANY_VALUES');
3193: FND_MSG_PUB.ADD;
3194: END IF;
3195:
3196: x_return_status := FND_API.G_RET_STS_ERROR;
3208: -- IF p_sales_credit_rec.salesgroup_id is NULL
3209: -- THEN
3210: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3211: -- THEN
3212: -- FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
3213: -- FND_MESSAGE.Set_Token('COLUMN', 'SALESGROUP_ID', FALSE);
3214: -- FND_MSG_PUB.ADD;
3215: -- END IF;
3216: --
3209: -- THEN
3210: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3211: -- THEN
3212: -- FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
3213: -- FND_MESSAGE.Set_Token('COLUMN', 'SALESGROUP_ID', FALSE);
3214: -- FND_MSG_PUB.ADD;
3215: -- END IF;
3216: --
3217: -- l_return_status := FND_API.G_RET_STS_ERROR;
3224: IF C_Salesforce_Person_Exists%NOTFOUND
3225: THEN
3226: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3227: THEN
3228: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
3229: FND_MESSAGE.Set_Token('COLUMN', 'SALESFORCE_ID, PERSON_ID', FALSE);
3230: FND_MESSAGE.Set_Token('VALUE', p_sales_credit_rec.salesforce_id || ',' ||
3231: p_sales_credit_rec.person_id, FALSE);
3232: FND_MSG_PUB.ADD;
3225: THEN
3226: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3227: THEN
3228: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
3229: FND_MESSAGE.Set_Token('COLUMN', 'SALESFORCE_ID, PERSON_ID', FALSE);
3230: FND_MESSAGE.Set_Token('VALUE', p_sales_credit_rec.salesforce_id || ',' ||
3231: p_sales_credit_rec.person_id, FALSE);
3232: FND_MSG_PUB.ADD;
3233: END IF;
3226: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3227: THEN
3228: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
3229: FND_MESSAGE.Set_Token('COLUMN', 'SALESFORCE_ID, PERSON_ID', FALSE);
3230: FND_MESSAGE.Set_Token('VALUE', p_sales_credit_rec.salesforce_id || ',' ||
3231: p_sales_credit_rec.person_id, FALSE);
3232: FND_MSG_PUB.ADD;
3233: END IF;
3234:
3246: IF C_Salesforce_Partner_Exists%NOTFOUND
3247: THEN
3248: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3249: THEN
3250: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
3251: FND_MESSAGE.Set_Token('COLUMN', 'SALESFORCE_ID, PARTNER_CUSTOMER_ID,
3252: PARTNER_ADDRESS_ID', FALSE);
3253: FND_MESSAGE.Set_Token('VALUE', p_sales_credit_rec.salesforce_id || ',' ||
3254: p_sales_credit_rec.partner_customer_id || ',' ||
3247: THEN
3248: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3249: THEN
3250: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
3251: FND_MESSAGE.Set_Token('COLUMN', 'SALESFORCE_ID, PARTNER_CUSTOMER_ID,
3252: PARTNER_ADDRESS_ID', FALSE);
3253: FND_MESSAGE.Set_Token('VALUE', p_sales_credit_rec.salesforce_id || ',' ||
3254: p_sales_credit_rec.partner_customer_id || ',' ||
3255: p_sales_credit_rec.partner_address_id , FALSE);
3249: THEN
3250: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
3251: FND_MESSAGE.Set_Token('COLUMN', 'SALESFORCE_ID, PARTNER_CUSTOMER_ID,
3252: PARTNER_ADDRESS_ID', FALSE);
3253: FND_MESSAGE.Set_Token('VALUE', p_sales_credit_rec.salesforce_id || ',' ||
3254: p_sales_credit_rec.partner_customer_id || ',' ||
3255: p_sales_credit_rec.partner_address_id , FALSE);
3256: FND_MSG_PUB.ADD;
3257: END IF;