DBA Data[Home] [Help]

APPS.IEM_TAG_KEY_PVT dependencies on FND_MESSAGE

Line 120: FND_MESSAGE.SET_NAME('IEM', 'IEM_ADMIN_TAG_NOT_DELETED');

116: --add names of un_deleted tags into message
117: if l_used_tag_name is not null then
118: l_used_tag_name := RTRIM(l_used_tag_name, ', ');
119: x_return_status := FND_API.G_RET_STS_ERROR;
120: FND_MESSAGE.SET_NAME('IEM', 'IEM_ADMIN_TAG_NOT_DELETED');
121: FND_MESSAGE.SET_TOKEN('TAG', l_used_tag_name);
122: FND_MSG_PUB.ADD;
123: /* FND_MSG_PUB.Count_And_Get
124: ( p_count => x_msg_count,

Line 121: FND_MESSAGE.SET_TOKEN('TAG', l_used_tag_name);

117: if l_used_tag_name is not null then
118: l_used_tag_name := RTRIM(l_used_tag_name, ', ');
119: x_return_status := FND_API.G_RET_STS_ERROR;
120: FND_MESSAGE.SET_NAME('IEM', 'IEM_ADMIN_TAG_NOT_DELETED');
121: FND_MESSAGE.SET_TOKEN('TAG', l_used_tag_name);
122: FND_MSG_PUB.ADD;
123: /* FND_MSG_PUB.Count_And_Get
124: ( p_count => x_msg_count,
125: p_data => x_msg_data

Line 144: FND_MESSAGE.SET_NAME('IEM', 'IEM_TAG_NOT_DELETED');

140:
141: WHEN IEM_TAG_NOT_DELETED THEN
142: ROLLBACK TO delete_item_batch;
143: x_return_status := FND_API.G_RET_STS_ERROR;
144: FND_MESSAGE.SET_NAME('IEM', 'IEM_TAG_NOT_DELETED');
145:
146: FND_MSG_PUB.ADD;
147: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
148:

Line 366: fnd_message.set_name ('IEM', 'IEM_TAG_INVALID_QUERY');

362: DBMS_SQL.PARSE(l_cursorid, l_value, DBMS_SQL.V7);
363:
364: EXCEPTION
365: WHEN OTHERS THEN
366: fnd_message.set_name ('IEM', 'IEM_TAG_INVALID_QUERY');
367: l_error_text := SUBSTR (SQLERRM , 1 , 240);
368: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_error_text);
369: FND_MSG_PUB.add;
370: DBMS_SQL.CLOSE_CURSOR(l_cursorid);

Line 368: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_error_text);

364: EXCEPTION
365: WHEN OTHERS THEN
366: fnd_message.set_name ('IEM', 'IEM_TAG_INVALID_QUERY');
367: l_error_text := SUBSTR (SQLERRM , 1 , 240);
368: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_error_text);
369: FND_MSG_PUB.add;
370: DBMS_SQL.CLOSE_CURSOR(l_cursorid);
371: RAISE l_invalid_query;
372: END;

Line 482: FND_MESSAGE.SET_NAME('IEM','IEM_TAG_NAME_VALUE_KEY_NULL');

478: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
479:
480: WHEN IEM_TAG_NAME_VALUE_KEY_NULL THEN
481: ROLLBACK TO create_item_tag_PVT;
482: FND_MESSAGE.SET_NAME('IEM','IEM_TAG_NAME_VALUE_KEY_NULL');
483: FND_MSG_PUB.Add;
484: x_return_status := FND_API.G_RET_STS_ERROR ;
485: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
486:

Line 489: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_G_MISS_FOR_NOTNULL');

485: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
486:
487: WHEN IEM_ADM_G_MISS_FOR_NOTNULL THEN
488: ROLLBACK TO create_item_tag_PVT;
489: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_G_MISS_FOR_NOTNULL');
490: FND_MSG_PUB.Add;
491: x_return_status := FND_API.G_RET_STS_ERROR ;
492: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
493:

Line 496: FND_MESSAGE.SET_NAME('IEM','IEM_TAG_DUP_KEY_NAME');

492: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
493:
494: WHEN IEM_TAG_DUP_KEY_NAME THEN
495: ROLLBACK TO create_item_tag_PVT;
496: FND_MESSAGE.SET_NAME('IEM','IEM_TAG_DUP_KEY_NAME');
497: FND_MSG_PUB.Add;
498: x_return_status := FND_API.G_RET_STS_ERROR ;
499: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
500:

Line 503: FND_MESSAGE.SET_NAME('IEM','IEM_TAG_DUP_KEY_ID');

499: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
500:
501: WHEN IEM_TAG_DUP_KEY_ID THEN
502: ROLLBACK TO create_item_tag_PVT;
503: FND_MESSAGE.SET_NAME('IEM','IEM_TAG_DUP_KEY_ID');
504: FND_MSG_PUB.Add;
505: x_return_status := FND_API.G_RET_STS_ERROR ;
506: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
507:

Line 702: FND_MESSAGE.SET_NAME('IEM','IEM_TAG_KEY_ID_NOT_EXIST');

698:
699: EXCEPTION
700: WHEN IEM_TAG_KEY_ID_NOT_EXIST THEN
701: ROLLBACK TO create_item_account_tags_PVT;
702: FND_MESSAGE.SET_NAME('IEM','IEM_TAG_KEY_ID_NOT_EXIST');
703: FND_MSG_PUB.Add;
704: x_return_status := FND_API.G_RET_STS_ERROR ;
705: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
706:

Line 709: FND_MESSAGE.SET_NAME('IEM','IEM_TAG_ACCT_ID_NOT_EXIST');

705: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
706:
707: WHEN IEM_TAG_ACCT_ID_NOT_EXIST THEN
708: ROLLBACK TO create_item_account_tags_PVT;
709: FND_MESSAGE.SET_NAME('IEM','IEM_TAG_ACCT_ID_NOT_EXIST');
710: FND_MSG_PUB.Add;
711: x_return_status := FND_API.G_RET_STS_ERROR ;
712: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
713:

Line 843: FND_MESSAGE.SET_NAME('IEM','IEM_ACCT_TAG_NOT_EXIST');

839:
840: EXCEPTION
841: WHEN NO_DATA_FOUND THEN
842: ROLLBACK TO update_acct_tag_wrap;
843: FND_MESSAGE.SET_NAME('IEM','IEM_ACCT_TAG_NOT_EXIST');
844: FND_MSG_PUB.Add;
845: x_return_status := FND_API.G_RET_STS_ERROR ;
846: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
847:

Line 850: FND_MESSAGE.SET_NAME('IEM','IEM_ACCT_TAG_NOT_UPD');

846: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
847:
848: WHEN IEM_ACCT_TAG_NOT_UPD THEN
849: ROLLBACK TO update_acct_tag_wrap;
850: FND_MESSAGE.SET_NAME('IEM','IEM_ACCT_TAG_NOT_UPD');
851: FND_MSG_PUB.Add;
852: x_return_status := FND_API.G_RET_STS_ERROR ;
853: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
854:

Line 961: fnd_message.set_name ('IEM', 'IEM_TAG_INVALID_QUERY');

957: DBMS_SQL.PARSE(l_cursorid, p_value, DBMS_SQL.V7);
958:
959: EXCEPTION
960: WHEN OTHERS THEN
961: fnd_message.set_name ('IEM', 'IEM_TAG_INVALID_QUERY');
962: l_error_text := SUBSTR (SQLERRM , 1 , 240);
963: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_error_text);
964: FND_MSG_PUB.add;
965: DBMS_SQL.CLOSE_CURSOR(l_cursorid);

Line 963: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_error_text);

959: EXCEPTION
960: WHEN OTHERS THEN
961: fnd_message.set_name ('IEM', 'IEM_TAG_INVALID_QUERY');
962: l_error_text := SUBSTR (SQLERRM , 1 , 240);
963: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_error_text);
964: FND_MSG_PUB.add;
965: DBMS_SQL.CLOSE_CURSOR(l_cursorid);
966: RAISE l_invalid_query;
967: END;

Line 1023: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_G_MISS_FOR_NOTNULL');

1019: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1020:
1021: WHEN IEM_ADM_G_MISS_FOR_NOTNULL THEN
1022: ROLLBACK TO update_item_tag_key;
1023: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_G_MISS_FOR_NOTNULL');
1024: FND_MSG_PUB.Add;
1025: x_return_status := FND_API.G_RET_STS_ERROR ;
1026: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1027:

Line 1030: FND_MESSAGE.SET_NAME('IEM','IEM_TAG_DUP_KEY_NAME');

1026: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1027:
1028: WHEN IEM_TAG_DUP_KEY_NAME THEN
1029: ROLLBACK TO update_item_tag_key;
1030: FND_MESSAGE.SET_NAME('IEM','IEM_TAG_DUP_KEY_NAME');
1031: FND_MSG_PUB.Add;
1032: x_return_status := FND_API.G_RET_STS_ERROR ;
1033: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1034:

Line 1037: FND_MESSAGE.SET_NAME('IEM','IEM_TAG_DUP_KEY_ID');

1033: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1034:
1035: WHEN IEM_TAG_DUP_KEY_ID THEN
1036: ROLLBACK TO update_item_tag_key;
1037: FND_MESSAGE.SET_NAME('IEM','IEM_TAG_DUP_KEY_ID');
1038: FND_MSG_PUB.Add;
1039: x_return_status := FND_API.G_RET_STS_ERROR ;
1040: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1041: