DBA Data[Home] [Help]

APPS.PV_CONTEXT_VALUES dependencies on FND_MSG_PUB

Line 337: FND_MSG_PUB.Add;

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.

Line 803: FND_MSG_PUB.Add;

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:

Line 1024: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1020: -- If there are no new partners, mark the flag for exiting
1021: -- the program.
1022: -- ---------------------------------------------------------
1023: IF (SQL%ROWCOUNT = 0) THEN
1024: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1025: p_msg_name => 'PV_NO_NEW_PARTNERS');
1026:
1027: p_end_refresh_flag := TRUE;
1028: RETURN;

Line 1268: FND_MSG_PUB.Add;

1264: FND_MESSAGE.Set_Name('PV', p_msg_type);
1265: FND_MESSAGE.Set_Token('TEXT', p_msg_string);
1266:
1267: IF (g_log_to_file = 'N') THEN
1268: FND_MSG_PUB.Add;
1269:
1270: ELSIF (g_log_to_file = 'Y') THEN
1271: FND_FILE.PUT_LINE( FND_FILE.LOG, fnd_message.get );
1272: END IF;

Line 1304: IF FND_MSG_PUB.Check_Msg_Level(p_msg_level) THEN

1300: p_token3_value IN VARCHAR2 := NULL
1301: )
1302: IS
1303: BEGIN
1304: IF FND_MSG_PUB.Check_Msg_Level(p_msg_level) THEN
1305: FND_MESSAGE.Set_Name('PV', p_msg_name);
1306: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
1307:
1308: IF (p_token1 IS NOT NULL) THEN

Line 1321: FND_MSG_PUB.Add;

1317: FND_MESSAGE.Set_Token(p_token3, p_token3_value);
1318: END IF;
1319:
1320: IF (g_log_to_file = 'N') THEN
1321: FND_MSG_PUB.Add;
1322:
1323: ELSIF (g_log_to_file = 'Y') THEN
1324: FND_FILE.PUT_LINE( FND_FILE.LOG, fnd_message.get );
1325: END IF;

Line 1766: fnd_msg_pub.reset(fnd_msg_pub.G_LAST);

1762: -- contains the exception raised by the called program
1763: -- e.g. currency_conversion
1764: -- -------------------------------------------------------------------
1765: -- Reset the pointer to the last message of the queue
1766: fnd_msg_pub.reset(fnd_msg_pub.G_LAST);
1767:
1768: -- -------------------------------------------------------------------
1769: -- Go back to the second to last message which contains the message
1770: -- raised by the called program (e.g. currency_conversion)

Line 1772: l_last_message := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_PREVIOUS,

1768: -- -------------------------------------------------------------------
1769: -- Go back to the second to last message which contains the message
1770: -- raised by the called program (e.g. currency_conversion)
1771: -- -------------------------------------------------------------------
1772: l_last_message := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_PREVIOUS,
1773: p_encoded => FND_API.g_false);
1774: l_last_message := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_PREVIOUS,
1775: p_encoded => FND_API.g_false);
1776: Debug(l_last_message);

Line 1774: l_last_message := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_PREVIOUS,

1770: -- raised by the called program (e.g. currency_conversion)
1771: -- -------------------------------------------------------------------
1772: l_last_message := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_PREVIOUS,
1773: p_encoded => FND_API.g_false);
1774: l_last_message := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_PREVIOUS,
1775: p_encoded => FND_API.g_false);
1776: Debug(l_last_message);
1777:
1778: Debug('Attribute ID: ' || x.attribute_id);

Line 2442: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

2438: ELSE
2439: l_start2 := dbms_utility.get_time;
2440:
2441: IF (x.batch_sql_text IS NULL) THEN
2442: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
2443: p_msg_name => 'PV_ABSENT_BATCH_SQL_TEXT',
2444: p_token1 => 'Attribute Name',
2445: p_token1_value => x.name,
2446: p_token2 => 'Attribute ID',

Line 2581: fnd_msg_pub.reset(fnd_msg_pub.G_LAST);

2577: -- contains the exception raised by the called program
2578: -- e.g. currency_conversion
2579: -- -------------------------------------------------------------------
2580: -- Reset the pointer to the last message of the queue
2581: fnd_msg_pub.reset(fnd_msg_pub.G_LAST);
2582:
2583: -- -------------------------------------------------------------------
2584: -- Go back to the second to last message which contains the message
2585: -- raised by the called program (e.g. currency_conversion)

Line 2587: l_last_message := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_PREVIOUS,

2583: -- -------------------------------------------------------------------
2584: -- Go back to the second to last message which contains the message
2585: -- raised by the called program (e.g. currency_conversion)
2586: -- -------------------------------------------------------------------
2587: l_last_message := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_PREVIOUS,
2588: p_encoded => FND_API.g_false);
2589: l_last_message := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_PREVIOUS,
2590: p_encoded => FND_API.g_false);
2591: Debug(l_last_message);

Line 2589: l_last_message := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_PREVIOUS,

2585: -- raised by the called program (e.g. currency_conversion)
2586: -- -------------------------------------------------------------------
2587: l_last_message := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_PREVIOUS,
2588: p_encoded => FND_API.g_false);
2589: l_last_message := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_PREVIOUS,
2590: p_encoded => FND_API.g_false);
2591: Debug(l_last_message);
2592:
2593: Debug('----------------------------------------------------');

Line 2755: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

2751:
2752: l_start2 := dbms_utility.get_time;
2753:
2754: IF (x.batch_sql_text IS NULL) THEN
2755: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
2756: p_msg_name => 'PV_ABSENT_BATCH_SQL_TEXT',
2757: p_token1 => 'Attribute Name',
2758: p_token1_value => x.name,
2759: p_token2 => 'Attribute ID',

Line 2949: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

2945:
2946: BEGIN
2947: IF (x.sql_text IS NULL OR LENGTH(x.sql_text) = 0) THEN
2948: Debug('&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&');
2949: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
2950: p_msg_name => 'PV_ABSENT_SQL_TEXT',
2951: p_token1 => 'Attribute Name',
2952: p_token1_value => x.name,
2953: p_token2 => 'Attribute ID',

Line 3297: fnd_msg_pub.reset(fnd_msg_pub.G_LAST);

3293: -- contains the exception raised by the called program
3294: -- e.g. currency_conversion
3295: -- -------------------------------------------------------------------
3296: -- Reset the pointer to the last message of the queue
3297: fnd_msg_pub.reset(fnd_msg_pub.G_LAST);
3298:
3299: -- -------------------------------------------------------------------
3300: -- Go back to the second to last message which contains the message
3301: -- raised by the called program (e.g. currency_conversion)

Line 3303: l_last_message := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_PREVIOUS,

3299: -- -------------------------------------------------------------------
3300: -- Go back to the second to last message which contains the message
3301: -- raised by the called program (e.g. currency_conversion)
3302: -- -------------------------------------------------------------------
3303: l_last_message := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_PREVIOUS,
3304: p_encoded => FND_API.g_false);
3305: l_last_message := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_PREVIOUS,
3306: p_encoded => FND_API.g_false);
3307: Debug(l_last_message);

Line 3305: l_last_message := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_PREVIOUS,

3301: -- raised by the called program (e.g. currency_conversion)
3302: -- -------------------------------------------------------------------
3303: l_last_message := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_PREVIOUS,
3304: p_encoded => FND_API.g_false);
3305: l_last_message := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_PREVIOUS,
3306: p_encoded => FND_API.g_false);
3307: Debug(l_last_message);
3308:
3309: Debug('Attribute ID: ' || p_attribute_id);

Line 3413: fnd_msg_pub.reset(fnd_msg_pub.G_LAST);

3409: -- contains the exception raised by the called program
3410: -- e.g. currency_conversion
3411: -- -------------------------------------------------------------------
3412: -- Reset the pointer to the last message of the queue
3413: fnd_msg_pub.reset(fnd_msg_pub.G_LAST);
3414:
3415: -- -------------------------------------------------------------------
3416: -- Go back to the second to last message which contains the message
3417: -- raised by the called program (e.g. currency_conversion)

Line 3419: l_last_message := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_PREVIOUS,

3415: -- -------------------------------------------------------------------
3416: -- Go back to the second to last message which contains the message
3417: -- raised by the called program (e.g. currency_conversion)
3418: -- -------------------------------------------------------------------
3419: l_last_message := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_PREVIOUS,
3420: p_encoded => FND_API.g_false);
3421: l_last_message := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_PREVIOUS,
3422: p_encoded => FND_API.g_false);
3423: Debug(l_last_message);

Line 3421: l_last_message := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_PREVIOUS,

3417: -- raised by the called program (e.g. currency_conversion)
3418: -- -------------------------------------------------------------------
3419: l_last_message := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_PREVIOUS,
3420: p_encoded => FND_API.g_false);
3421: l_last_message := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_PREVIOUS,
3422: p_encoded => FND_API.g_false);
3423: Debug(l_last_message);
3424:
3425: Debug('Attribute ID: ' || p_attribute_id);