333: FND_FILE.PUT_LINE( FND_FILE.LOG, fnd_message.get );
334: FND_FILE.NEW_LINE( FND_FILE.LOG, 1 );
335:
336: ELSE
337: FND_MSG_PUB.Add;
338: END IF;
339:
340: -- -----------------------------------------------------------------------
341: -- Retrieve the last incremental refresh date from the profile.
799: FND_FILE.PUT_LINE( FND_FILE.LOG, fnd_message.get );
800: FND_FILE.NEW_LINE( FND_FILE.LOG, 1 );
801:
802: ELSE
803: FND_MSG_PUB.Add;
804: END IF;
805:
806:
807:
1042: -- If there are no new partners, mark the flag for exiting
1043: -- the program.
1044: -- ---------------------------------------------------------
1045: IF (SQL%ROWCOUNT = 0) THEN
1046: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1047: p_msg_name => 'PV_NO_NEW_PARTNERS');
1048:
1049: p_end_refresh_flag := TRUE;
1050: RETURN;
1286: FND_MESSAGE.Set_Name('PV', p_msg_type);
1287: FND_MESSAGE.Set_Token('TEXT', p_msg_string);
1288:
1289: IF (g_log_to_file = 'N') THEN
1290: FND_MSG_PUB.Add;
1291:
1292: ELSIF (g_log_to_file = 'Y') THEN
1293: FND_FILE.PUT_LINE( FND_FILE.LOG, fnd_message.get );
1294: END IF;
1322: p_token3_value IN VARCHAR2 := NULL
1323: )
1324: IS
1325: BEGIN
1326: IF FND_MSG_PUB.Check_Msg_Level(p_msg_level) THEN
1327: FND_MESSAGE.Set_Name('PV', p_msg_name);
1328: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
1329:
1330: IF (p_token1 IS NOT NULL) THEN
1339: FND_MESSAGE.Set_Token(p_token3, p_token3_value);
1340: END IF;
1341:
1342: IF (g_log_to_file = 'N') THEN
1343: FND_MSG_PUB.Add;
1344:
1345: ELSIF (g_log_to_file = 'Y') THEN
1346: FND_FILE.PUT_LINE( FND_FILE.LOG, fnd_message.get );
1347: END IF;
1784: -- contains the exception raised by the called program
1785: -- e.g. currency_conversion
1786: -- -------------------------------------------------------------------
1787: -- Reset the pointer to the last message of the queue
1788: fnd_msg_pub.reset(fnd_msg_pub.G_LAST);
1789:
1790: -- -------------------------------------------------------------------
1791: -- Go back to the second to last message which contains the message
1792: -- raised by the called program (e.g. currency_conversion)
1790: -- -------------------------------------------------------------------
1791: -- Go back to the second to last message which contains the message
1792: -- raised by the called program (e.g. currency_conversion)
1793: -- -------------------------------------------------------------------
1794: l_last_message := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_PREVIOUS,
1795: p_encoded => FND_API.g_false);
1796: l_last_message := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_PREVIOUS,
1797: p_encoded => FND_API.g_false);
1798: Debug(l_last_message);
1792: -- raised by the called program (e.g. currency_conversion)
1793: -- -------------------------------------------------------------------
1794: l_last_message := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_PREVIOUS,
1795: p_encoded => FND_API.g_false);
1796: l_last_message := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_PREVIOUS,
1797: p_encoded => FND_API.g_false);
1798: Debug(l_last_message);
1799:
1800: Debug('Attribute ID: ' || x.attribute_id);
2460: ELSE
2461: l_start2 := dbms_utility.get_time;
2462:
2463: IF (x.batch_sql_text IS NULL) THEN
2464: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
2465: p_msg_name => 'PV_ABSENT_BATCH_SQL_TEXT',
2466: p_token1 => 'Attribute Name',
2467: p_token1_value => x.name,
2468: p_token2 => 'Attribute ID',
2599: -- contains the exception raised by the called program
2600: -- e.g. currency_conversion
2601: -- -------------------------------------------------------------------
2602: -- Reset the pointer to the last message of the queue
2603: fnd_msg_pub.reset(fnd_msg_pub.G_LAST);
2604:
2605: -- -------------------------------------------------------------------
2606: -- Go back to the second to last message which contains the message
2607: -- raised by the called program (e.g. currency_conversion)
2605: -- -------------------------------------------------------------------
2606: -- Go back to the second to last message which contains the message
2607: -- raised by the called program (e.g. currency_conversion)
2608: -- -------------------------------------------------------------------
2609: l_last_message := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_PREVIOUS,
2610: p_encoded => FND_API.g_false);
2611: l_last_message := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_PREVIOUS,
2612: p_encoded => FND_API.g_false);
2613: Debug(l_last_message);
2607: -- raised by the called program (e.g. currency_conversion)
2608: -- -------------------------------------------------------------------
2609: l_last_message := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_PREVIOUS,
2610: p_encoded => FND_API.g_false);
2611: l_last_message := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_PREVIOUS,
2612: p_encoded => FND_API.g_false);
2613: Debug(l_last_message);
2614:
2615: Debug('----------------------------------------------------');
2773:
2774: l_start2 := dbms_utility.get_time;
2775:
2776: IF (x.batch_sql_text IS NULL) THEN
2777: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
2778: p_msg_name => 'PV_ABSENT_BATCH_SQL_TEXT',
2779: p_token1 => 'Attribute Name',
2780: p_token1_value => x.name,
2781: p_token2 => 'Attribute ID',
2967:
2968: BEGIN
2969: IF (x.sql_text IS NULL OR LENGTH(x.sql_text) = 0) THEN
2970: Debug('&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&');
2971: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
2972: p_msg_name => 'PV_ABSENT_SQL_TEXT',
2973: p_token1 => 'Attribute Name',
2974: p_token1_value => x.name,
2975: p_token2 => 'Attribute ID',
3315: -- contains the exception raised by the called program
3316: -- e.g. currency_conversion
3317: -- -------------------------------------------------------------------
3318: -- Reset the pointer to the last message of the queue
3319: fnd_msg_pub.reset(fnd_msg_pub.G_LAST);
3320:
3321: -- -------------------------------------------------------------------
3322: -- Go back to the second to last message which contains the message
3323: -- raised by the called program (e.g. currency_conversion)
3321: -- -------------------------------------------------------------------
3322: -- Go back to the second to last message which contains the message
3323: -- raised by the called program (e.g. currency_conversion)
3324: -- -------------------------------------------------------------------
3325: l_last_message := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_PREVIOUS,
3326: p_encoded => FND_API.g_false);
3327: l_last_message := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_PREVIOUS,
3328: p_encoded => FND_API.g_false);
3329: Debug(l_last_message);
3323: -- raised by the called program (e.g. currency_conversion)
3324: -- -------------------------------------------------------------------
3325: l_last_message := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_PREVIOUS,
3326: p_encoded => FND_API.g_false);
3327: l_last_message := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_PREVIOUS,
3328: p_encoded => FND_API.g_false);
3329: Debug(l_last_message);
3330:
3331: Debug('Attribute ID: ' || p_attribute_id);
3431: -- contains the exception raised by the called program
3432: -- e.g. currency_conversion
3433: -- -------------------------------------------------------------------
3434: -- Reset the pointer to the last message of the queue
3435: fnd_msg_pub.reset(fnd_msg_pub.G_LAST);
3436:
3437: -- -------------------------------------------------------------------
3438: -- Go back to the second to last message which contains the message
3439: -- raised by the called program (e.g. currency_conversion)
3437: -- -------------------------------------------------------------------
3438: -- Go back to the second to last message which contains the message
3439: -- raised by the called program (e.g. currency_conversion)
3440: -- -------------------------------------------------------------------
3441: l_last_message := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_PREVIOUS,
3442: p_encoded => FND_API.g_false);
3443: l_last_message := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_PREVIOUS,
3444: p_encoded => FND_API.g_false);
3445: Debug(l_last_message);
3439: -- raised by the called program (e.g. currency_conversion)
3440: -- -------------------------------------------------------------------
3441: l_last_message := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_PREVIOUS,
3442: p_encoded => FND_API.g_false);
3443: l_last_message := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_PREVIOUS,
3444: p_encoded => FND_API.g_false);
3445: Debug(l_last_message);
3446:
3447: Debug('Attribute ID: ' || p_attribute_id);