APPS.AK_AMPARAM_REGISTRY_PVT dependencies on FND_MSG_PUB

Line 67: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

63: p_APPLICATIONMODULE_DEFN_NAME => l_ap_registry_rec.APPLICATIONMODULE_DEFN_NAME,
64: p_application_id => l_ap_registry_rec.application_id
65: )
66: then
67: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
68: FND_MESSAGE.SET_NAME('AK','AK_AP_REGISTRY_NOT_DOWNLOADED');
69: FND_MESSAGE.SET_TOKEN('KEY', p_APPLICATIONMODULE_DEFN_NAME);
70: FND_MSG_PUB.Add;
71: end if;

Line 70: FND_MSG_PUB.Add;

66: then
67: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
68: FND_MESSAGE.SET_NAME('AK','AK_AP_REGISTRY_NOT_DOWNLOADED');
69: FND_MESSAGE.SET_TOKEN('KEY', p_APPLICATIONMODULE_DEFN_NAME);
70: FND_MSG_PUB.Add;
71: end if;
72: close l_get_ap_registry_csr;
73: raise FND_API.G_EXC_ERROR;
74: end if;

Line 131: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

127: p_return_status := FND_API.G_RET_STS_SUCCESS;
128:
129: EXCEPTION
130: WHEN VALUE_ERROR THEN
131: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
132: FND_MESSAGE.SET_NAME('AK','AK_AP_REGISTRY_VALUE_ERROR');
133: FND_MESSAGE.SET_TOKEN('KEY', p_APPLICATIONMODULE_DEFN_NAME);
134: FND_MSG_PUB.Add;
135: end if;

Line 134: FND_MSG_PUB.Add;

130: WHEN VALUE_ERROR THEN
131: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
132: FND_MESSAGE.SET_NAME('AK','AK_AP_REGISTRY_VALUE_ERROR');
133: FND_MESSAGE.SET_TOKEN('KEY', p_APPLICATIONMODULE_DEFN_NAME);
134: FND_MSG_PUB.Add;
135: end if;
136: p_return_status := FND_API.G_RET_STS_ERROR;
137: WHEN FND_API.G_EXC_ERROR THEN
138: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 138: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

134: FND_MSG_PUB.Add;
135: end if;
136: p_return_status := FND_API.G_RET_STS_ERROR;
137: WHEN FND_API.G_EXC_ERROR THEN
138: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
139: FND_MESSAGE.SET_NAME('AK','AK_AP_REGISTRY_NOT_DOWNLOADED');
140: FND_MESSAGE.SET_TOKEN('KEY', p_APPLICATIONMODULE_DEFN_NAME);
141: FND_MSG_PUB.Add;
142: end if;

Line 141: FND_MSG_PUB.Add;

137: WHEN FND_API.G_EXC_ERROR THEN
138: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
139: FND_MESSAGE.SET_NAME('AK','AK_AP_REGISTRY_NOT_DOWNLOADED');
140: FND_MESSAGE.SET_TOKEN('KEY', p_APPLICATIONMODULE_DEFN_NAME);
141: FND_MSG_PUB.Add;
142: end if;
143: p_return_status := FND_API.G_RET_STS_ERROR;
144: WHEN OTHERS THEN
145: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 146: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

142: end if;
143: p_return_status := FND_API.G_RET_STS_ERROR;
144: WHEN OTHERS THEN
145: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
146: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
147: SUBSTR (SQLERRM, 1, 240) );
148: FND_MSG_PUB.Add;
149: end WRITE_TO_BUFFER;
150:

Line 148: FND_MSG_PUB.Add;

144: WHEN OTHERS THEN
145: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
146: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
147: SUBSTR (SQLERRM, 1, 240) );
148: FND_MSG_PUB.Add;
149: end WRITE_TO_BUFFER;
150:
151: --=======================================================
152: -- Procedure DOWNLOAD_AMPARAM_REGISTRY

Line 226: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

222: -- - query codes in p_queryobj_PK_tbl
223:
224: if (p_application_id = FND_API.G_MISS_NUM) or (p_application_id is null) then
225: if (p_amparamreg_pk_tbl.count = 0) then
226: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
227: FND_MESSAGE.SET_NAME('AK','AK_NO_SELECTION');
228: FND_MSG_PUB.Add;
229: end if;
230: raise FND_API.G_EXC_ERROR;

Line 228: FND_MSG_PUB.Add;

224: if (p_application_id = FND_API.G_MISS_NUM) or (p_application_id is null) then
225: if (p_amparamreg_pk_tbl.count = 0) then
226: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
227: FND_MESSAGE.SET_NAME('AK','AK_NO_SELECTION');
228: FND_MSG_PUB.Add;
229: end if;
230: raise FND_API.G_EXC_ERROR;
231: end if;
232: else

Line 236: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

232: else
233: if (p_amparamreg_pk_tbl.count > 0) then
234: -- both application ID and a list of objects to be extracted are
235: -- given, issue a warning that we will ignore the application ID
236: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
237: FND_MESSAGE.SET_NAME('AK','AK_APPL_ID_IGNORED');
238: FND_MSG_PUB.Add;
239: end if;
240: end if;

Line 238: FND_MSG_PUB.Add;

234: -- both application ID and a list of objects to be extracted are
235: -- given, issue a warning that we will ignore the application ID
236: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
237: FND_MESSAGE.SET_NAME('AK','AK_APPL_ID_IGNORED');
238: FND_MSG_PUB.Add;
239: end if;
240: end if;
241: end if;
242:

Line 299: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

295: -- to_char(sysdate, 'MON-DD HH24:MI:SS'));
296:
297: EXCEPTION
298: WHEN VALUE_ERROR THEN
299: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
300: FND_MESSAGE.SET_NAME('AK','AK_APREG_PK_VALUE_ERROR');
301: FND_MSG_PUB.Add;
302: end if;
303: -- dbms_output.put_line('Value error occurred in download- check your object list.');

Line 301: FND_MSG_PUB.Add;

297: EXCEPTION
298: WHEN VALUE_ERROR THEN
299: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
300: FND_MESSAGE.SET_NAME('AK','AK_APREG_PK_VALUE_ERROR');
301: FND_MSG_PUB.Add;
302: end if;
303: -- dbms_output.put_line('Value error occurred in download- check your object list.');
304: p_return_status := FND_API.G_RET_STS_ERROR;
305: WHEN FND_API.G_EXC_ERROR THEN

Line 309: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,

305: WHEN FND_API.G_EXC_ERROR THEN
306: p_return_status := FND_API.G_RET_STS_ERROR;
307: WHEN OTHERS THEN
308: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
309: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
310: SUBSTR (SQLERRM, 1, 240) );
311: end DOWNLOAD_AMPARAM_REGISTRY;
312:
313:

Line 338: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

334: p_api_version_number,
335: l_return_status,
336: p_application_id) ) ) then
337: l_error := TRUE;
338: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
339: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
340: FND_MESSAGE.SET_TOKEN('COLUMN','APPLICATION_ID');
341: FND_MSG_PUB.Add;
342: end if;

Line 341: FND_MSG_PUB.Add;

337: l_error := TRUE;
338: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
339: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
340: FND_MESSAGE.SET_TOKEN('COLUMN','APPLICATION_ID');
341: FND_MSG_PUB.Add;
342: end if;
343: end if;
344: p_return_status := FND_API.G_RET_STS_SUCCESS;
345: return (not l_error);

Line 350: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

346:
347: EXCEPTION
348: WHEN OTHERS THEN
349: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
350: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
351: SUBSTR (SQLERRM, 1, 240) );
352: FND_MSG_PUB.Add;
353:
354: END VALIDATE_AP_REGISTRY;

Line 352: FND_MSG_PUB.Add;

348: WHEN OTHERS THEN
349: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
350: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
351: SUBSTR (SQLERRM, 1, 240) );
352: FND_MSG_PUB.Add;
353:
354: END VALIDATE_AP_REGISTRY;
355:
356: --=======================================================

Line 408: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

404: p_return_status := FND_API.G_RET_STS_ERROR;
405: return FALSE;
406: WHEN OTHERS THEN
407: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
408: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
409: SUBSTR (SQLERRM, 1, 240) );
410: FND_MSG_PUB.Add;
411: return FALSE;
412: END AMPARAM_REGISTRY_EXISTS;

Line 410: FND_MSG_PUB.Add;

406: WHEN OTHERS THEN
407: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
408: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
409: SUBSTR (SQLERRM, 1, 240) );
410: FND_MSG_PUB.Add;
411: return FALSE;
412: END AMPARAM_REGISTRY_EXISTS;
413:
414:

Line 471: FND_MSG_PUB.initialize;

467:
468: -- Initialize the message table if requested.
469:
470: if p_init_msg_tbl then
471: FND_MSG_PUB.initialize;
472: end if;
473:
474: savepoint start_create_amparam;
475:

Line 484: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

480: p_applicationmodule_defn_name => p_applicationmodule_defn_name,
481: p_param_name => p_param_name,
482: p_param_value => p_param_value,
483: p_application_id => p_application_id) then
484: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
485: FND_MESSAGE.SET_NAME('AK','AK_AMPARAM_REGISTRY_EXISTS');
486: FND_MSG_PUB.Add;
487: end if;
488: -- dbms_output.put_line(G_PKG_NAME || 'Error - Row already exists');

Line 486: FND_MSG_PUB.Add;

482: p_param_value => p_param_value,
483: p_application_id => p_application_id) then
484: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
485: FND_MESSAGE.SET_NAME('AK','AK_AMPARAM_REGISTRY_EXISTS');
486: FND_MSG_PUB.Add;
487: end if;
488: -- dbms_output.put_line(G_PKG_NAME || 'Error - Row already exists');
489: raise FND_API.G_EXC_ERROR;
490: end if;

Line 516: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN

512: p_param_name,
513: p_param_value,
514: p_application_id);
515:
516: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
517: FND_MESSAGE.SET_NAME('AK','AK_AMPARAM_REGISTRY_CREATED');
518: FND_MESSAGE.SET_TOKEN('KEY', p_applicationmodule_defn_name);
519: FND_MSG_PUB.Add;
520: end if;

Line 519: FND_MSG_PUB.Add;

515:
516: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
517: FND_MESSAGE.SET_NAME('AK','AK_AMPARAM_REGISTRY_CREATED');
518: FND_MESSAGE.SET_TOKEN('KEY', p_applicationmodule_defn_name);
519: FND_MSG_PUB.Add;
520: end if;
521:
522: p_return_status := FND_API.G_RET_STS_SUCCESS;
523:

Line 524: FND_MSG_PUB.Count_And_Get (

520: end if;
521:
522: p_return_status := FND_API.G_RET_STS_SUCCESS;
523:
524: FND_MSG_PUB.Count_And_Get (
525: p_count => p_msg_count,
526: p_data => p_msg_data);
527:
528: EXCEPTION

Line 530: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

526: p_data => p_msg_data);
527:
528: EXCEPTION
529: WHEN VALUE_ERROR THEN
530: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
531: FND_MESSAGE.SET_NAME('AK','AK_AMPARAM_VALUE_ERROR');
532: FND_MESSAGE.SET_TOKEN('KEY', p_applicationmodule_defn_name);
533: FND_MSG_PUB.Add;
534: end if;

Line 533: FND_MSG_PUB.Add;

529: WHEN VALUE_ERROR THEN
530: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
531: FND_MESSAGE.SET_NAME('AK','AK_AMPARAM_VALUE_ERROR');
532: FND_MESSAGE.SET_TOKEN('KEY', p_applicationmodule_defn_name);
533: FND_MSG_PUB.Add;
534: end if;
535: p_return_status := FND_API.G_RET_STS_ERROR;
536: rollback to start_create_amparam;
537: FND_MSG_PUB.Count_And_Get (

Line 537: FND_MSG_PUB.Count_And_Get (

533: FND_MSG_PUB.Add;
534: end if;
535: p_return_status := FND_API.G_RET_STS_ERROR;
536: rollback to start_create_amparam;
537: FND_MSG_PUB.Count_And_Get (
538: p_count => p_msg_count,
539: p_data => p_msg_data);
540: WHEN FND_API.G_EXC_ERROR THEN
541: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 541: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

537: FND_MSG_PUB.Count_And_Get (
538: p_count => p_msg_count,
539: p_data => p_msg_data);
540: WHEN FND_API.G_EXC_ERROR THEN
541: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
542: FND_MESSAGE.SET_NAME('AK','AK_AMPARAM_NOT_CREATED');
543: FND_MESSAGE.SET_TOKEN('KEY', p_applicationmodule_defn_name);
544: FND_MSG_PUB.Add;
545: end if;

Line 544: FND_MSG_PUB.Add;

540: WHEN FND_API.G_EXC_ERROR THEN
541: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
542: FND_MESSAGE.SET_NAME('AK','AK_AMPARAM_NOT_CREATED');
543: FND_MESSAGE.SET_TOKEN('KEY', p_applicationmodule_defn_name);
544: FND_MSG_PUB.Add;
545: end if;
546: p_return_status := FND_API.G_RET_STS_ERROR;
547: rollback to start_create_amparam;
548: FND_MSG_PUB.Count_And_Get (

Line 548: FND_MSG_PUB.Count_And_Get (

544: FND_MSG_PUB.Add;
545: end if;
546: p_return_status := FND_API.G_RET_STS_ERROR;
547: rollback to start_create_amparam;
548: FND_MSG_PUB.Count_And_Get (
549: p_count => p_msg_count,
550: p_data => p_msg_data);
551: WHEN OTHERS THEN
552: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 554: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

550: p_data => p_msg_data);
551: WHEN OTHERS THEN
552: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
553: rollback to start_create_amparam;
554: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
555: SUBSTR (SQLERRM, 1, 240) );
556: FND_MSG_PUB.Add;
557: FND_MSG_PUB.Count_And_Get (
558: p_count => p_msg_count,

Line 556: FND_MSG_PUB.Add;

552: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
553: rollback to start_create_amparam;
554: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
555: SUBSTR (SQLERRM, 1, 240) );
556: FND_MSG_PUB.Add;
557: FND_MSG_PUB.Count_And_Get (
558: p_count => p_msg_count,
559: p_data => p_msg_data);
560:

Line 557: FND_MSG_PUB.Count_And_Get (

553: rollback to start_create_amparam;
554: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
555: SUBSTR (SQLERRM, 1, 240) );
556: FND_MSG_PUB.Add;
557: FND_MSG_PUB.Count_And_Get (
558: p_count => p_msg_count,
559: p_data => p_msg_data);
560:
561: END CREATE_AMPARAM_REGISTRY;

Line 626: FND_MSG_PUB.initialize;

622:
623: -- Initialize the message table if requested.
624:
625: if p_init_msg_tbl then
626: FND_MSG_PUB.initialize;
627: end if;
628:
629: savepoint start_update_amparam;
630:

Line 635: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

631: --** retrieve ak_regions row if it exists **
632: open l_get_amparam_registry_csr;
633: fetch l_get_amparam_registry_csr into l_amparam_reg_rec;
634: if (l_get_amparam_registry_csr%notfound) then
635: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
636: FND_MESSAGE.SET_NAME('AK','AK_QUERYOBJ_DOES_NOT_EXIST');
637: FND_MSG_PUB.Add;
638: end if;
639: --dbms_output.put_line(l_api_name || 'Error - Row does not exist');

Line 637: FND_MSG_PUB.Add;

633: fetch l_get_amparam_registry_csr into l_amparam_reg_rec;
634: if (l_get_amparam_registry_csr%notfound) then
635: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
636: FND_MESSAGE.SET_NAME('AK','AK_QUERYOBJ_DOES_NOT_EXIST');
637: FND_MSG_PUB.Add;
638: end if;
639: --dbms_output.put_line(l_api_name || 'Error - Row does not exist');
640: close l_get_amparam_registry_csr;
641: raise FND_API.G_EXC_ERROR;

Line 651: FND_MSG_PUB.Add;

647: p_return_status => l_return_status,
648: p_application_id => p_application_id) ) then
649: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
650: FND_MESSAGE.SET_TOKEN('COLUMN','APPLICATION_ID');
651: FND_MSG_PUB.Add;
652: raise FND_API.G_EXC_ERROR;
653: end if;
654:
655: l_amparam_reg_rec.application_id := p_application_id;

Line 676: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

672: and param_name = p_param_name
673: and param_source = p_param_value;
674:
675: if (sql%notfound) then
676: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
677: FND_MESSAGE.SET_NAME('AK','AK_QUERYOBJ_UPDATE_FAILED');
678: FND_MSG_PUB.Add;
679: end if;
680: raise FND_API.G_EXC_ERROR;

Line 678: FND_MSG_PUB.Add;

674:
675: if (sql%notfound) then
676: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
677: FND_MESSAGE.SET_NAME('AK','AK_QUERYOBJ_UPDATE_FAILED');
678: FND_MSG_PUB.Add;
679: end if;
680: raise FND_API.G_EXC_ERROR;
681: end if;
682:

Line 683: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN

679: end if;
680: raise FND_API.G_EXC_ERROR;
681: end if;
682:
683: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
684: FND_MESSAGE.SET_NAME('AK','AK_AMPARAM_REG_UPDATED');
685: FND_MESSAGE.SET_TOKEN('KEY', p_applicationmodule_defn_name);
686: FND_MSG_PUB.Add;
687: end if;

Line 686: FND_MSG_PUB.Add;

682:
683: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
684: FND_MESSAGE.SET_NAME('AK','AK_AMPARAM_REG_UPDATED');
685: FND_MESSAGE.SET_TOKEN('KEY', p_applicationmodule_defn_name);
686: FND_MSG_PUB.Add;
687: end if;
688:
689: p_return_status := FND_API.G_RET_STS_SUCCESS;
690:

Line 691: FND_MSG_PUB.Count_And_Get (

687: end if;
688:
689: p_return_status := FND_API.G_RET_STS_SUCCESS;
690:
691: FND_MSG_PUB.Count_And_Get (
692: p_count => p_msg_count,
693: p_data => p_msg_data);
694:
695: EXCEPTION

Line 697: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

693: p_data => p_msg_data);
694:
695: EXCEPTION
696: WHEN VALUE_ERROR THEN
697: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
698: FND_MESSAGE.SET_NAME('AK','AK_AMPARAM_VALUE_ERROR');
699: FND_MESSAGE.SET_TOKEN('KEY', p_applicationmodule_defn_name);
700: FND_MSG_PUB.Add;
701: end if;

Line 700: FND_MSG_PUB.Add;

696: WHEN VALUE_ERROR THEN
697: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
698: FND_MESSAGE.SET_NAME('AK','AK_AMPARAM_VALUE_ERROR');
699: FND_MESSAGE.SET_TOKEN('KEY', p_applicationmodule_defn_name);
700: FND_MSG_PUB.Add;
701: end if;
702: rollback to start_update_amparam;
703: p_return_status := FND_API.G_RET_STS_ERROR;
704: FND_MSG_PUB.Count_And_Get (

Line 704: FND_MSG_PUB.Count_And_Get (

700: FND_MSG_PUB.Add;
701: end if;
702: rollback to start_update_amparam;
703: p_return_status := FND_API.G_RET_STS_ERROR;
704: FND_MSG_PUB.Count_And_Get (
705: p_count => p_msg_count,
706: p_data => p_msg_data);
707: WHEN FND_API.G_EXC_ERROR THEN
708: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 708: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

704: FND_MSG_PUB.Count_And_Get (
705: p_count => p_msg_count,
706: p_data => p_msg_data);
707: WHEN FND_API.G_EXC_ERROR THEN
708: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
709: FND_MESSAGE.SET_NAME('AK','AK_AMPARAM_REG_NOT_UPDATED');
710: FND_MESSAGE.SET_TOKEN('KEY', p_applicationmodule_defn_name);
711: FND_MSG_PUB.Add;
712: end if;

Line 711: FND_MSG_PUB.Add;

707: WHEN FND_API.G_EXC_ERROR THEN
708: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
709: FND_MESSAGE.SET_NAME('AK','AK_AMPARAM_REG_NOT_UPDATED');
710: FND_MESSAGE.SET_TOKEN('KEY', p_applicationmodule_defn_name);
711: FND_MSG_PUB.Add;
712: end if;
713: p_return_status := FND_API.G_RET_STS_ERROR;
714: rollback to start_update_amparam;
715: FND_MSG_PUB.Count_And_Get (

Line 715: FND_MSG_PUB.Count_And_Get (

711: FND_MSG_PUB.Add;
712: end if;
713: p_return_status := FND_API.G_RET_STS_ERROR;
714: rollback to start_update_amparam;
715: FND_MSG_PUB.Count_And_Get (
716: p_count => p_msg_count,
717: p_data => p_msg_data);
718: WHEN OTHERS THEN
719: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 721: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

717: p_data => p_msg_data);
718: WHEN OTHERS THEN
719: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
720: rollback to start_update_amparam;
721: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
722: SUBSTR (SQLERRM, 1, 240) );
723: FND_MSG_PUB.Add;
724: FND_MSG_PUB.Count_And_Get (
725: p_count => p_msg_count,

Line 723: FND_MSG_PUB.Add;

719: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
720: rollback to start_update_amparam;
721: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
722: SUBSTR (SQLERRM, 1, 240) );
723: FND_MSG_PUB.Add;
724: FND_MSG_PUB.Count_And_Get (
725: p_count => p_msg_count,
726: p_data => p_msg_data);
727: FND_MSG_PUB.Count_And_Get (

Line 724: FND_MSG_PUB.Count_And_Get (

720: rollback to start_update_amparam;
721: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
722: SUBSTR (SQLERRM, 1, 240) );
723: FND_MSG_PUB.Add;
724: FND_MSG_PUB.Count_And_Get (
725: p_count => p_msg_count,
726: p_data => p_msg_data);
727: FND_MSG_PUB.Count_And_Get (
728: p_count => p_msg_count,

Line 727: FND_MSG_PUB.Count_And_Get (

723: FND_MSG_PUB.Add;
724: FND_MSG_PUB.Count_And_Get (
725: p_count => p_msg_count,
726: p_data => p_msg_data);
727: FND_MSG_PUB.Count_And_Get (
728: p_count => p_msg_count,
729: p_data => p_msg_data);
730:
731: END UPDATE_AMPARAM_REGISTRY;

Line 877: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

873: --
874: -- Error if there is nothing to be read from the file
875: --
876: if (l_buffer is null and l_eof_flag = 'Y') then
877: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
878: FND_MESSAGE.SET_NAME('AK','AK_EMPTY_BUFFER');
879: FND_MSG_PUB.Add;
880: end if;
881: raise FND_API.G_EXC_ERROR;

Line 879: FND_MSG_PUB.Add;

875: --
876: if (l_buffer is null and l_eof_flag = 'Y') then
877: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
878: FND_MESSAGE.SET_NAME('AK','AK_EMPTY_BUFFER');
879: FND_MSG_PUB.Add;
880: end if;
881: raise FND_API.G_EXC_ERROR;
882: end if;
883:

Line 899: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

895: --dbms_output.put_line(' State:' || l_state || 'Token:' || l_token);
896:
897: if (l_return_status = FND_API.G_RET_STS_ERROR) or
898: (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
899: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
900: FND_MESSAGE.SET_NAME('AK','AK_GET_TOKEN_ERROR');
901: FND_MSG_PUB.Add;
902: end if;
903: --dbms_output.put_line(l_api_name || ' Error parsing buffer');

Line 901: FND_MSG_PUB.Add;

897: if (l_return_status = FND_API.G_RET_STS_ERROR) or
898: (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
899: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
900: FND_MESSAGE.SET_NAME('AK','AK_GET_TOKEN_ERROR');
901: FND_MSG_PUB.Add;
902: end if;
903: --dbms_output.put_line(l_api_name || ' Error parsing buffer');
904: raise FND_API.G_EXC_ERROR;
905: end if;

Line 915: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

911: if (l_state = 0) then
912: if (l_token = 'BEGIN') then
913: l_state := 1;
914: else
915: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
916: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
917: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
918: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
919: FND_MESSAGE.SET_TOKEN('EXPECTED','BEGIN');

Line 920: FND_MSG_PUB.Add;

916: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
917: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
918: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
919: FND_MESSAGE.SET_TOKEN('EXPECTED','BEGIN');
920: FND_MSG_PUB.Add;
921: end if;
922: raise FND_API.G_EXC_ERROR;
923: end if;
924: elsif (l_state = 1) then

Line 941: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

937: if (l_token is not null) then
938: l_amparam_rec.applicationmodule_defn_name := l_token;
939: l_state := 3;
940: else
941: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
942: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
943: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
944: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
945: FND_MESSAGE.SET_TOKEN('EXPECTED','APPLICATIONMODULE_DEFN_NAME');

Line 946: FND_MSG_PUB.Add;

942: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
943: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
944: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
945: FND_MESSAGE.SET_TOKEN('EXPECTED','APPLICATIONMODULE_DEFN_NAME');
946: FND_MSG_PUB.Add;
947: end if;
948: raise FND_API.G_EXC_ERROR;
949: end if;
950: elsif (l_state = 3) then

Line 955: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

951: if (l_token is not null) then
952: l_amparam_rec.param_name := l_token;
953: l_state := 4;
954: else
955: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
956: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
957: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
958: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
959: FND_MESSAGE.SET_TOKEN('EXPECTED','PARAM_NAME');

Line 960: FND_MSG_PUB.Add;

956: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
957: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
958: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
959: FND_MESSAGE.SET_TOKEN('EXPECTED','PARAM_NAME');
960: FND_MSG_PUB.Add;
961: end if;
962: raise FND_API.G_EXC_ERROR;
963: end if;
964: elsif ( l_state = 4) then

Line 970: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

966: l_amparam_rec.param_source := l_token;
967: l_state := 10;
968: l_value_count := null;
969: else
970: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
971: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
972: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
973: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
974: FND_MESSAGE.SET_TOKEN('EXPECTED','PARAM_VALUE');

Line 975: FND_MSG_PUB.Add;

971: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
972: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
973: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
974: FND_MESSAGE.SET_TOKEN('EXPECTED','PARAM_VALUE');
975: FND_MSG_PUB.Add;
976: end if;
977: raise FND_API.G_EXC_ERROR;
978: end if;
979: elsif (l_state = 10) then

Line 1001: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

997: l_saved_token := l_token;
998: end if;
999: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
1000: (l_value_count is null) then
1001: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1002: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
1003: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1004: if (l_value_count is null) then
1005: FND_MESSAGE.SET_TOKEN('TOKEN', l_token||'(debug: l_buffer = '||l_buffer||' l_state = '||to_char(l_state)||')');

Line 1010: FND_MSG_PUB.Add;

1006: else
1007: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
1008: end if;
1009: FND_MESSAGE.SET_TOKEN('EXPECTED','AMPARAM_REGISTRY');
1010: FND_MSG_PUB.Add;
1011: end if;
1012: -- dbms_output.put_line('Expecting region field, BEGIN, or END');
1013: raise FND_API.G_EXC_ERROR;
1014: end if;

Line 1020: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1016: elsif (l_state = 11) then
1017: if (l_token = '=') then
1018: l_state := 12;
1019: else
1020: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1021: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1022: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1023: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1024: FND_MESSAGE.SET_TOKEN('EXPECTED','=');

Line 1025: FND_MSG_PUB.Add;

1021: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1022: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1023: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1024: FND_MESSAGE.SET_TOKEN('EXPECTED','=');
1025: FND_MSG_PUB.Add;
1026: end if;
1027: raise FND_API.G_EXC_ERROR;
1028: end if;
1029: elsif (l_state = 12) then

Line 1035: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1031: if (l_column = 'APPLICATION_ID') then
1032: l_amparam_rec.application_id := to_number(l_token);
1033: l_state := 10;
1034: else
1035: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1036: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1037: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1038: FND_MESSAGE.SET_TOKEN('TOKEN',l_token||' (debug: l_buffer = '||l_buffer||' l_state = '||to_char(l_state)||')');
1039: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);

Line 1040: FND_MSG_PUB.Add;

1036: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1037: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1038: FND_MESSAGE.SET_TOKEN('TOKEN',l_token||' (debug: l_buffer = '||l_buffer||' l_state = '||to_char(l_state)||')');
1039: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
1040: FND_MSG_PUB.Add;
1041: end if;
1042: raise FND_API.G_EXC_ERROR;
1043: end if;
1044: elsif (l_state = 19) then

Line 1090: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1086: RAISE FND_API.G_EXC_ERROR;
1087: end if; -- /* if l_return_status */
1088: l_state := 0;
1089: else
1090: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1091: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1092: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1093: FND_MESSAGE.SET_TOKEN('TOKEN',l_token||' (debug: l_buffer = '||l_buffer||' l_state = '||to_char(l_state)||')');
1094: FND_MESSAGE.SET_TOKEN('EXPECTED', 'AMPARAM_REGISTRY');

Line 1095: FND_MSG_PUB.Add;

1091: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1092: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1093: FND_MESSAGE.SET_TOKEN('TOKEN',l_token||' (debug: l_buffer = '||l_buffer||' l_state = '||to_char(l_state)||')');
1094: FND_MESSAGE.SET_TOKEN('EXPECTED', 'AMPARAM_REGISTRY');
1095: FND_MSG_PUB.Add;
1096: end if;
1097: raise FND_API.G_EXC_ERROR;
1098: end if;
1099:

Line 1137: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1133: -- If the loops end in a state other then at the end of a region
1134: -- (state 0) or when the beginning of another business object was
1135: -- detected, then the file must have ended prematurely, which is an error
1136: if (l_state <> 0) and (l_more_apregistry) then
1137: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1138: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1139: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1140: FND_MESSAGE.SET_TOKEN('TOKEN', 'END OF FILE');
1141: FND_MESSAGE.SET_TOKEN('EXPECTED', null);

Line 1142: FND_MSG_PUB.Add;

1138: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1139: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1140: FND_MESSAGE.SET_TOKEN('TOKEN', 'END OF FILE');
1141: FND_MESSAGE.SET_TOKEN('EXPECTED', null);
1142: FND_MSG_PUB.Add;
1143: end if;
1144: --dbms_output.put_line('Unexpected END OF FILE: state is ' ||
1145: -- to_char(l_state));
1146: raise FND_API.G_EXC_ERROR;

Line 1165: FND_MSG_PUB.Add;

1161: WHEN VALUE_ERROR THEN
1162: p_return_status := FND_API.G_RET_STS_ERROR;
1163: FND_MESSAGE.SET_NAME('AK','AK_REGION_VALUE_ERROR');
1164: FND_MESSAGE.SET_TOKEN('KEY',l_amparam_rec.applicationmodule_defn_name);
1165: FND_MSG_PUB.Add;
1166: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1167: SUBSTR (SQLERRM, 1, 240)||': '||l_column||'='||l_token );
1168: FND_MSG_PUB.Add;
1169: WHEN OTHERS THEN

Line 1166: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

1162: p_return_status := FND_API.G_RET_STS_ERROR;
1163: FND_MESSAGE.SET_NAME('AK','AK_REGION_VALUE_ERROR');
1164: FND_MESSAGE.SET_TOKEN('KEY',l_amparam_rec.applicationmodule_defn_name);
1165: FND_MSG_PUB.Add;
1166: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1167: SUBSTR (SQLERRM, 1, 240)||': '||l_column||'='||l_token );
1168: FND_MSG_PUB.Add;
1169: WHEN OTHERS THEN
1170: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1168: FND_MSG_PUB.Add;

1164: FND_MESSAGE.SET_TOKEN('KEY',l_amparam_rec.applicationmodule_defn_name);
1165: FND_MSG_PUB.Add;
1166: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1167: SUBSTR (SQLERRM, 1, 240)||': '||l_column||'='||l_token );
1168: FND_MSG_PUB.Add;
1169: WHEN OTHERS THEN
1170: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1171: rollback to Start_Upload;
1172: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

Line 1172: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

1168: FND_MSG_PUB.Add;
1169: WHEN OTHERS THEN
1170: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1171: rollback to Start_Upload;
1172: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1173: SUBSTR (SQLERRM, 1, 240) );
1174: FND_MSG_PUB.Add;
1175: end UPLOAD_AMPARAM_REGISTRY;
1176:

Line 1174: FND_MSG_PUB.Add;

1170: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1171: rollback to Start_Upload;
1172: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1173: SUBSTR (SQLERRM, 1, 240) );
1174: FND_MSG_PUB.Add;
1175: end UPLOAD_AMPARAM_REGISTRY;
1176:
1177: end AK_AMPARAM_REGISTRY_PVT;