eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EGO_ITEM_ASSOCIATIONS_PUB dependencies on FND_MESSAGE

Line 466: l_msg_data := FND_MESSAGE.GET_ENCODED();

462: EXECUTE IMMEDIATE l_dynamic_sql
463: USING IN p_batch_id;
464: END IF;
465: ELSE
466: l_msg_data := FND_MESSAGE.GET_ENCODED();
467: fnd_message.set_name ('EGO', 'EGO_PLSQL_ERR');
468: fnd_message.set_token ('PKG_NAME', G_PKG_NAME);
469: fnd_message.set_token ('API_NAME', 'check_security');
470: fnd_message.set_token ('SQL_ERR_MSG', l_msg_data);

Line 467: fnd_message.set_name ('EGO', 'EGO_PLSQL_ERR');

463: USING IN p_batch_id;
464: END IF;
465: ELSE
466: l_msg_data := FND_MESSAGE.GET_ENCODED();
467: fnd_message.set_name ('EGO', 'EGO_PLSQL_ERR');
468: fnd_message.set_token ('PKG_NAME', G_PKG_NAME);
469: fnd_message.set_token ('API_NAME', 'check_security');
470: fnd_message.set_token ('SQL_ERR_MSG', l_msg_data);
471: APP_EXCEPTION.RAISE_EXCEPTION();

Line 468: fnd_message.set_token ('PKG_NAME', G_PKG_NAME);

464: END IF;
465: ELSE
466: l_msg_data := FND_MESSAGE.GET_ENCODED();
467: fnd_message.set_name ('EGO', 'EGO_PLSQL_ERR');
468: fnd_message.set_token ('PKG_NAME', G_PKG_NAME);
469: fnd_message.set_token ('API_NAME', 'check_security');
470: fnd_message.set_token ('SQL_ERR_MSG', l_msg_data);
471: APP_EXCEPTION.RAISE_EXCEPTION();
472: END IF;

Line 469: fnd_message.set_token ('API_NAME', 'check_security');

465: ELSE
466: l_msg_data := FND_MESSAGE.GET_ENCODED();
467: fnd_message.set_name ('EGO', 'EGO_PLSQL_ERR');
468: fnd_message.set_token ('PKG_NAME', G_PKG_NAME);
469: fnd_message.set_token ('API_NAME', 'check_security');
470: fnd_message.set_token ('SQL_ERR_MSG', l_msg_data);
471: APP_EXCEPTION.RAISE_EXCEPTION();
472: END IF;
473: EGO_DATA_SECURITY.get_security_predicate

Line 470: fnd_message.set_token ('SQL_ERR_MSG', l_msg_data);

466: l_msg_data := FND_MESSAGE.GET_ENCODED();
467: fnd_message.set_name ('EGO', 'EGO_PLSQL_ERR');
468: fnd_message.set_token ('PKG_NAME', G_PKG_NAME);
469: fnd_message.set_token ('API_NAME', 'check_security');
470: fnd_message.set_token ('SQL_ERR_MSG', l_msg_data);
471: APP_EXCEPTION.RAISE_EXCEPTION();
472: END IF;
473: EGO_DATA_SECURITY.get_security_predicate
474: (p_api_version => 1.0

Line 500: l_msg_data := FND_MESSAGE.GET_ENCODED();

496: EXECUTE IMMEDIATE l_dynamic_sql
497: USING IN p_batch_id;
498: END IF;
499: ELSE
500: l_msg_data := FND_MESSAGE.GET_ENCODED();
501: fnd_message.set_name ('EGO', 'EGO_PLSQL_ERR');
502: fnd_message.set_token ('PKG_NAME', G_PKG_NAME);
503: fnd_message.set_token ('API_NAME', 'check_security');
504: fnd_message.set_token ('SQL_ERR_MSG', l_msg_data);

Line 501: fnd_message.set_name ('EGO', 'EGO_PLSQL_ERR');

497: USING IN p_batch_id;
498: END IF;
499: ELSE
500: l_msg_data := FND_MESSAGE.GET_ENCODED();
501: fnd_message.set_name ('EGO', 'EGO_PLSQL_ERR');
502: fnd_message.set_token ('PKG_NAME', G_PKG_NAME);
503: fnd_message.set_token ('API_NAME', 'check_security');
504: fnd_message.set_token ('SQL_ERR_MSG', l_msg_data);
505: APP_EXCEPTION.RAISE_EXCEPTION();

Line 502: fnd_message.set_token ('PKG_NAME', G_PKG_NAME);

498: END IF;
499: ELSE
500: l_msg_data := FND_MESSAGE.GET_ENCODED();
501: fnd_message.set_name ('EGO', 'EGO_PLSQL_ERR');
502: fnd_message.set_token ('PKG_NAME', G_PKG_NAME);
503: fnd_message.set_token ('API_NAME', 'check_security');
504: fnd_message.set_token ('SQL_ERR_MSG', l_msg_data);
505: APP_EXCEPTION.RAISE_EXCEPTION();
506: END IF;

Line 503: fnd_message.set_token ('API_NAME', 'check_security');

499: ELSE
500: l_msg_data := FND_MESSAGE.GET_ENCODED();
501: fnd_message.set_name ('EGO', 'EGO_PLSQL_ERR');
502: fnd_message.set_token ('PKG_NAME', G_PKG_NAME);
503: fnd_message.set_token ('API_NAME', 'check_security');
504: fnd_message.set_token ('SQL_ERR_MSG', l_msg_data);
505: APP_EXCEPTION.RAISE_EXCEPTION();
506: END IF;
507: EGO_DATA_SECURITY.get_security_predicate

Line 504: fnd_message.set_token ('SQL_ERR_MSG', l_msg_data);

500: l_msg_data := FND_MESSAGE.GET_ENCODED();
501: fnd_message.set_name ('EGO', 'EGO_PLSQL_ERR');
502: fnd_message.set_token ('PKG_NAME', G_PKG_NAME);
503: fnd_message.set_token ('API_NAME', 'check_security');
504: fnd_message.set_token ('SQL_ERR_MSG', l_msg_data);
505: APP_EXCEPTION.RAISE_EXCEPTION();
506: END IF;
507: EGO_DATA_SECURITY.get_security_predicate
508: (p_api_version => 1.0

Line 535: l_msg_data := FND_MESSAGE.GET_ENCODED();

531: EXECUTE IMMEDIATE l_dynamic_sql
532: USING IN p_batch_id;
533: END IF;
534: ELSE
535: l_msg_data := FND_MESSAGE.GET_ENCODED();
536: fnd_message.set_name ('EGO', 'EGO_PLSQL_ERR');
537: fnd_message.set_token ('PKG_NAME', G_PKG_NAME);
538: fnd_message.set_token ('API_NAME', 'check_security');
539: fnd_message.set_token ('SQL_ERR_MSG', l_msg_data);

Line 536: fnd_message.set_name ('EGO', 'EGO_PLSQL_ERR');

532: USING IN p_batch_id;
533: END IF;
534: ELSE
535: l_msg_data := FND_MESSAGE.GET_ENCODED();
536: fnd_message.set_name ('EGO', 'EGO_PLSQL_ERR');
537: fnd_message.set_token ('PKG_NAME', G_PKG_NAME);
538: fnd_message.set_token ('API_NAME', 'check_security');
539: fnd_message.set_token ('SQL_ERR_MSG', l_msg_data);
540: APP_EXCEPTION.RAISE_EXCEPTION();

Line 537: fnd_message.set_token ('PKG_NAME', G_PKG_NAME);

533: END IF;
534: ELSE
535: l_msg_data := FND_MESSAGE.GET_ENCODED();
536: fnd_message.set_name ('EGO', 'EGO_PLSQL_ERR');
537: fnd_message.set_token ('PKG_NAME', G_PKG_NAME);
538: fnd_message.set_token ('API_NAME', 'check_security');
539: fnd_message.set_token ('SQL_ERR_MSG', l_msg_data);
540: APP_EXCEPTION.RAISE_EXCEPTION();
541: END IF;

Line 538: fnd_message.set_token ('API_NAME', 'check_security');

534: ELSE
535: l_msg_data := FND_MESSAGE.GET_ENCODED();
536: fnd_message.set_name ('EGO', 'EGO_PLSQL_ERR');
537: fnd_message.set_token ('PKG_NAME', G_PKG_NAME);
538: fnd_message.set_token ('API_NAME', 'check_security');
539: fnd_message.set_token ('SQL_ERR_MSG', l_msg_data);
540: APP_EXCEPTION.RAISE_EXCEPTION();
541: END IF;
542:

Line 539: fnd_message.set_token ('SQL_ERR_MSG', l_msg_data);

535: l_msg_data := FND_MESSAGE.GET_ENCODED();
536: fnd_message.set_name ('EGO', 'EGO_PLSQL_ERR');
537: fnd_message.set_token ('PKG_NAME', G_PKG_NAME);
538: fnd_message.set_token ('API_NAME', 'check_security');
539: fnd_message.set_token ('SQL_ERR_MSG', l_msg_data);
540: APP_EXCEPTION.RAISE_EXCEPTION();
541: END IF;
542:
543: IF ego_item_associations_util.is_supplier_contact(G_PARTY_ID) = FND_API.G_TRUE THEN

Line 1443: fnd_message.set_name('EGO','EGO_ASSOC_MISSING_REQ_VALUE');

1439: BEGIN
1440: FOR l_err_rec IN l_err_rows_csr(p_batch_id)
1441: LOOP
1442: IF l_err_rec.process_flag = G_REC_MISSING_REQ_VALUE THEN
1443: fnd_message.set_name('EGO','EGO_ASSOC_MISSING_REQ_VALUE');
1444: ELSIF l_err_rec.process_flag = G_REC_INVALID_TRAN_TYPE THEN
1445: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_TRAN_TYPE');
1446: ELSIF l_err_rec.process_flag = G_REC_INVALID_MASTER_ORG THEN
1447: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_MASTER_ORG');

Line 1445: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_TRAN_TYPE');

1441: LOOP
1442: IF l_err_rec.process_flag = G_REC_MISSING_REQ_VALUE THEN
1443: fnd_message.set_name('EGO','EGO_ASSOC_MISSING_REQ_VALUE');
1444: ELSIF l_err_rec.process_flag = G_REC_INVALID_TRAN_TYPE THEN
1445: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_TRAN_TYPE');
1446: ELSIF l_err_rec.process_flag = G_REC_INVALID_MASTER_ORG THEN
1447: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_MASTER_ORG');
1448: ELSIF l_err_rec.process_flag = G_REC_INVALID_ORG THEN
1449: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_ORG');

Line 1447: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_MASTER_ORG');

1443: fnd_message.set_name('EGO','EGO_ASSOC_MISSING_REQ_VALUE');
1444: ELSIF l_err_rec.process_flag = G_REC_INVALID_TRAN_TYPE THEN
1445: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_TRAN_TYPE');
1446: ELSIF l_err_rec.process_flag = G_REC_INVALID_MASTER_ORG THEN
1447: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_MASTER_ORG');
1448: ELSIF l_err_rec.process_flag = G_REC_INVALID_ORG THEN
1449: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_ORG');
1450: ELSIF l_err_rec.process_flag = G_REC_INVALID_ITEM THEN
1451: fnd_message.set_name('EGO','EGO_ASSOC_ITEM_NOT_IN_ORG');

Line 1449: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_ORG');

1445: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_TRAN_TYPE');
1446: ELSIF l_err_rec.process_flag = G_REC_INVALID_MASTER_ORG THEN
1447: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_MASTER_ORG');
1448: ELSIF l_err_rec.process_flag = G_REC_INVALID_ORG THEN
1449: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_ORG');
1450: ELSIF l_err_rec.process_flag = G_REC_INVALID_ITEM THEN
1451: fnd_message.set_name('EGO','EGO_ASSOC_ITEM_NOT_IN_ORG');
1452: ELSIF l_err_rec.process_flag = G_REC_INVALID_PK1_VALUE THEN
1453: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_PK1_VALUE');

Line 1451: fnd_message.set_name('EGO','EGO_ASSOC_ITEM_NOT_IN_ORG');

1447: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_MASTER_ORG');
1448: ELSIF l_err_rec.process_flag = G_REC_INVALID_ORG THEN
1449: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_ORG');
1450: ELSIF l_err_rec.process_flag = G_REC_INVALID_ITEM THEN
1451: fnd_message.set_name('EGO','EGO_ASSOC_ITEM_NOT_IN_ORG');
1452: ELSIF l_err_rec.process_flag = G_REC_INVALID_PK1_VALUE THEN
1453: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_PK1_VALUE');
1454: ELSIF l_err_rec.process_flag = G_REC_INVALID_PK2_VALUE THEN
1455: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_PK2_VALUE');

Line 1453: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_PK1_VALUE');

1449: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_ORG');
1450: ELSIF l_err_rec.process_flag = G_REC_INVALID_ITEM THEN
1451: fnd_message.set_name('EGO','EGO_ASSOC_ITEM_NOT_IN_ORG');
1452: ELSIF l_err_rec.process_flag = G_REC_INVALID_PK1_VALUE THEN
1453: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_PK1_VALUE');
1454: ELSIF l_err_rec.process_flag = G_REC_INVALID_PK2_VALUE THEN
1455: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_PK2_VALUE');
1456: ELSIF l_err_rec.process_flag = G_REC_INVALID_ASSOC_TYPE THEN
1457: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_ASSOC_TYPE');

Line 1455: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_PK2_VALUE');

1451: fnd_message.set_name('EGO','EGO_ASSOC_ITEM_NOT_IN_ORG');
1452: ELSIF l_err_rec.process_flag = G_REC_INVALID_PK1_VALUE THEN
1453: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_PK1_VALUE');
1454: ELSIF l_err_rec.process_flag = G_REC_INVALID_PK2_VALUE THEN
1455: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_PK2_VALUE');
1456: ELSIF l_err_rec.process_flag = G_REC_INVALID_ASSOC_TYPE THEN
1457: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_ASSOC_TYPE');
1458: ELSIF l_err_rec.process_flag = G_REC_INVALID_STATUS THEN
1459: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_STATUS');

Line 1457: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_ASSOC_TYPE');

1453: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_PK1_VALUE');
1454: ELSIF l_err_rec.process_flag = G_REC_INVALID_PK2_VALUE THEN
1455: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_PK2_VALUE');
1456: ELSIF l_err_rec.process_flag = G_REC_INVALID_ASSOC_TYPE THEN
1457: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_ASSOC_TYPE');
1458: ELSIF l_err_rec.process_flag = G_REC_INVALID_STATUS THEN
1459: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_STATUS');
1460: ELSIF l_err_rec.process_flag = G_REC_INVALID_PRIMARY THEN
1461: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_PRIMARY');

Line 1459: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_STATUS');

1455: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_PK2_VALUE');
1456: ELSIF l_err_rec.process_flag = G_REC_INVALID_ASSOC_TYPE THEN
1457: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_ASSOC_TYPE');
1458: ELSIF l_err_rec.process_flag = G_REC_INVALID_STATUS THEN
1459: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_STATUS');
1460: ELSIF l_err_rec.process_flag = G_REC_INVALID_PRIMARY THEN
1461: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_PRIMARY');
1462: ELSIF l_err_rec.process_flag = G_REC_ASSOCIATION_NOT_EXISTS THEN
1463: fnd_message.set_name('EGO','EGO_ASSOC_NOT_EXISTS');

Line 1461: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_PRIMARY');

1457: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_ASSOC_TYPE');
1458: ELSIF l_err_rec.process_flag = G_REC_INVALID_STATUS THEN
1459: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_STATUS');
1460: ELSIF l_err_rec.process_flag = G_REC_INVALID_PRIMARY THEN
1461: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_PRIMARY');
1462: ELSIF l_err_rec.process_flag = G_REC_ASSOCIATION_NOT_EXISTS THEN
1463: fnd_message.set_name('EGO','EGO_ASSOC_NOT_EXISTS');
1464: ELSIF l_err_rec.process_flag = G_REC_ALREADY_ASSIGNED THEN
1465: fnd_message.set_name('EGO','EGO_ASSOC_ALREADY_ASSIGNED');

Line 1463: fnd_message.set_name('EGO','EGO_ASSOC_NOT_EXISTS');

1459: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_STATUS');
1460: ELSIF l_err_rec.process_flag = G_REC_INVALID_PRIMARY THEN
1461: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_PRIMARY');
1462: ELSIF l_err_rec.process_flag = G_REC_ASSOCIATION_NOT_EXISTS THEN
1463: fnd_message.set_name('EGO','EGO_ASSOC_NOT_EXISTS');
1464: ELSIF l_err_rec.process_flag = G_REC_ALREADY_ASSIGNED THEN
1465: fnd_message.set_name('EGO','EGO_ASSOC_ALREADY_ASSIGNED');
1466: ELSIF l_err_rec.process_flag = G_REC_ASSOC_SITE_NOT_EXISTS THEN
1467: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_PK2_VALUE');

Line 1465: fnd_message.set_name('EGO','EGO_ASSOC_ALREADY_ASSIGNED');

1461: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_PRIMARY');
1462: ELSIF l_err_rec.process_flag = G_REC_ASSOCIATION_NOT_EXISTS THEN
1463: fnd_message.set_name('EGO','EGO_ASSOC_NOT_EXISTS');
1464: ELSIF l_err_rec.process_flag = G_REC_ALREADY_ASSIGNED THEN
1465: fnd_message.set_name('EGO','EGO_ASSOC_ALREADY_ASSIGNED');
1466: ELSIF l_err_rec.process_flag = G_REC_ASSOC_SITE_NOT_EXISTS THEN
1467: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_PK2_VALUE');
1468: ELSIF l_err_rec.process_flag = G_REC_ASSOC_ITEM_NOT_IN_ORG THEN
1469: fnd_message.set_name('EGO','EGO_ASSOC_ITEM_NOT_IN_ORG');

Line 1467: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_PK2_VALUE');

1463: fnd_message.set_name('EGO','EGO_ASSOC_NOT_EXISTS');
1464: ELSIF l_err_rec.process_flag = G_REC_ALREADY_ASSIGNED THEN
1465: fnd_message.set_name('EGO','EGO_ASSOC_ALREADY_ASSIGNED');
1466: ELSIF l_err_rec.process_flag = G_REC_ASSOC_SITE_NOT_EXISTS THEN
1467: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_PK2_VALUE');
1468: ELSIF l_err_rec.process_flag = G_REC_ASSOC_ITEM_NOT_IN_ORG THEN
1469: fnd_message.set_name('EGO','EGO_ASSOC_ITEM_NOT_IN_ORG');
1470: ELSIF l_err_rec.process_flag = G_REC_PARENT_NOT_ASSIGNED THEN
1471: fnd_message.set_name('EGO','EGO_ASSOC_PARENT_NOT_ASSIGNED');

Line 1469: fnd_message.set_name('EGO','EGO_ASSOC_ITEM_NOT_IN_ORG');

1465: fnd_message.set_name('EGO','EGO_ASSOC_ALREADY_ASSIGNED');
1466: ELSIF l_err_rec.process_flag = G_REC_ASSOC_SITE_NOT_EXISTS THEN
1467: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_PK2_VALUE');
1468: ELSIF l_err_rec.process_flag = G_REC_ASSOC_ITEM_NOT_IN_ORG THEN
1469: fnd_message.set_name('EGO','EGO_ASSOC_ITEM_NOT_IN_ORG');
1470: ELSIF l_err_rec.process_flag = G_REC_PARENT_NOT_ASSIGNED THEN
1471: fnd_message.set_name('EGO','EGO_ASSOC_PARENT_NOT_ASSIGNED');
1472: ELSIF l_err_rec.process_flag = G_REC_PARENT_NOT_ACTIVE THEN
1473: fnd_message.set_name('EGO','EGO_ASSOC_PARENT_NOT_ACTIVE');

Line 1471: fnd_message.set_name('EGO','EGO_ASSOC_PARENT_NOT_ASSIGNED');

1467: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_PK2_VALUE');
1468: ELSIF l_err_rec.process_flag = G_REC_ASSOC_ITEM_NOT_IN_ORG THEN
1469: fnd_message.set_name('EGO','EGO_ASSOC_ITEM_NOT_IN_ORG');
1470: ELSIF l_err_rec.process_flag = G_REC_PARENT_NOT_ASSIGNED THEN
1471: fnd_message.set_name('EGO','EGO_ASSOC_PARENT_NOT_ASSIGNED');
1472: ELSIF l_err_rec.process_flag = G_REC_PARENT_NOT_ACTIVE THEN
1473: fnd_message.set_name('EGO','EGO_ASSOC_PARENT_NOT_ACTIVE');
1474: ELSIF l_err_rec.process_flag = G_REC_PRIMARY_NOT_ACTIVE THEN
1475: fnd_message.set_name('EGO','EGO_ASSOC_PRIMARY_NOT_ACTIVE');

Line 1473: fnd_message.set_name('EGO','EGO_ASSOC_PARENT_NOT_ACTIVE');

1469: fnd_message.set_name('EGO','EGO_ASSOC_ITEM_NOT_IN_ORG');
1470: ELSIF l_err_rec.process_flag = G_REC_PARENT_NOT_ASSIGNED THEN
1471: fnd_message.set_name('EGO','EGO_ASSOC_PARENT_NOT_ASSIGNED');
1472: ELSIF l_err_rec.process_flag = G_REC_PARENT_NOT_ACTIVE THEN
1473: fnd_message.set_name('EGO','EGO_ASSOC_PARENT_NOT_ACTIVE');
1474: ELSIF l_err_rec.process_flag = G_REC_PRIMARY_NOT_ACTIVE THEN
1475: fnd_message.set_name('EGO','EGO_ASSOC_PRIMARY_NOT_ACTIVE');
1476: /*
1477: ELSIF l_err_rec.process_flag = G_REC_DUPLICATE THEN

Line 1475: fnd_message.set_name('EGO','EGO_ASSOC_PRIMARY_NOT_ACTIVE');

1471: fnd_message.set_name('EGO','EGO_ASSOC_PARENT_NOT_ASSIGNED');
1472: ELSIF l_err_rec.process_flag = G_REC_PARENT_NOT_ACTIVE THEN
1473: fnd_message.set_name('EGO','EGO_ASSOC_PARENT_NOT_ACTIVE');
1474: ELSIF l_err_rec.process_flag = G_REC_PRIMARY_NOT_ACTIVE THEN
1475: fnd_message.set_name('EGO','EGO_ASSOC_PRIMARY_NOT_ACTIVE');
1476: /*
1477: ELSIF l_err_rec.process_flag = G_REC_DUPLICATE THEN
1478: fnd_message.set_name('EGO','EGO_ASSOC_DUPLICATE');
1479: fnd_message.set_token('TRANSACTION_ID',l_err_rec.transaction_id);

Line 1478: fnd_message.set_name('EGO','EGO_ASSOC_DUPLICATE');

1474: ELSIF l_err_rec.process_flag = G_REC_PRIMARY_NOT_ACTIVE THEN
1475: fnd_message.set_name('EGO','EGO_ASSOC_PRIMARY_NOT_ACTIVE');
1476: /*
1477: ELSIF l_err_rec.process_flag = G_REC_DUPLICATE THEN
1478: fnd_message.set_name('EGO','EGO_ASSOC_DUPLICATE');
1479: fnd_message.set_token('TRANSACTION_ID',l_err_rec.transaction_id);
1480: fnd_message.set_token('ITEM_NAME',l_err_rec.item_number);
1481: fnd_message.set_token('ORG_CODE',l_err_rec.organization_code);
1482: fnd_message.set_token('DATA_LEVEL',l_err_rec.data_level_id); -- Do we allow to enter user enterable field

Line 1479: fnd_message.set_token('TRANSACTION_ID',l_err_rec.transaction_id);

1475: fnd_message.set_name('EGO','EGO_ASSOC_PRIMARY_NOT_ACTIVE');
1476: /*
1477: ELSIF l_err_rec.process_flag = G_REC_DUPLICATE THEN
1478: fnd_message.set_name('EGO','EGO_ASSOC_DUPLICATE');
1479: fnd_message.set_token('TRANSACTION_ID',l_err_rec.transaction_id);
1480: fnd_message.set_token('ITEM_NAME',l_err_rec.item_number);
1481: fnd_message.set_token('ORG_CODE',l_err_rec.organization_code);
1482: fnd_message.set_token('DATA_LEVEL',l_err_rec.data_level_id); -- Do we allow to enter user enterable field
1483: */

Line 1480: fnd_message.set_token('ITEM_NAME',l_err_rec.item_number);

1476: /*
1477: ELSIF l_err_rec.process_flag = G_REC_DUPLICATE THEN
1478: fnd_message.set_name('EGO','EGO_ASSOC_DUPLICATE');
1479: fnd_message.set_token('TRANSACTION_ID',l_err_rec.transaction_id);
1480: fnd_message.set_token('ITEM_NAME',l_err_rec.item_number);
1481: fnd_message.set_token('ORG_CODE',l_err_rec.organization_code);
1482: fnd_message.set_token('DATA_LEVEL',l_err_rec.data_level_id); -- Do we allow to enter user enterable field
1483: */
1484: ELSIF l_err_rec.process_flag = G_REC_NO_CREATE_ASSOC_PRIV THEN

Line 1481: fnd_message.set_token('ORG_CODE',l_err_rec.organization_code);

1477: ELSIF l_err_rec.process_flag = G_REC_DUPLICATE THEN
1478: fnd_message.set_name('EGO','EGO_ASSOC_DUPLICATE');
1479: fnd_message.set_token('TRANSACTION_ID',l_err_rec.transaction_id);
1480: fnd_message.set_token('ITEM_NAME',l_err_rec.item_number);
1481: fnd_message.set_token('ORG_CODE',l_err_rec.organization_code);
1482: fnd_message.set_token('DATA_LEVEL',l_err_rec.data_level_id); -- Do we allow to enter user enterable field
1483: */
1484: ELSIF l_err_rec.process_flag = G_REC_NO_CREATE_ASSOC_PRIV THEN
1485: fnd_message.set_name('EGO','EGO_ASSOC_NO_CREATE_ASSOC_PRIV');

Line 1482: fnd_message.set_token('DATA_LEVEL',l_err_rec.data_level_id); -- Do we allow to enter user enterable field

1478: fnd_message.set_name('EGO','EGO_ASSOC_DUPLICATE');
1479: fnd_message.set_token('TRANSACTION_ID',l_err_rec.transaction_id);
1480: fnd_message.set_token('ITEM_NAME',l_err_rec.item_number);
1481: fnd_message.set_token('ORG_CODE',l_err_rec.organization_code);
1482: fnd_message.set_token('DATA_LEVEL',l_err_rec.data_level_id); -- Do we allow to enter user enterable field
1483: */
1484: ELSIF l_err_rec.process_flag = G_REC_NO_CREATE_ASSOC_PRIV THEN
1485: fnd_message.set_name('EGO','EGO_ASSOC_NO_CREATE_ASSOC_PRIV');
1486: ELSIF l_err_rec.process_flag = G_REC_NO_EDIT_ASSOC_PRIV THEN

Line 1485: fnd_message.set_name('EGO','EGO_ASSOC_NO_CREATE_ASSOC_PRIV');

1481: fnd_message.set_token('ORG_CODE',l_err_rec.organization_code);
1482: fnd_message.set_token('DATA_LEVEL',l_err_rec.data_level_id); -- Do we allow to enter user enterable field
1483: */
1484: ELSIF l_err_rec.process_flag = G_REC_NO_CREATE_ASSOC_PRIV THEN
1485: fnd_message.set_name('EGO','EGO_ASSOC_NO_CREATE_ASSOC_PRIV');
1486: ELSIF l_err_rec.process_flag = G_REC_NO_EDIT_ASSOC_PRIV THEN
1487: fnd_message.set_name('EGO','EGO_ASSOC_NO_EDIT_ASSOC_PRIV');
1488: ELSIF l_err_rec.process_flag = G_REC_NO_SUPPL_ACCESS_PRIV THEN
1489: fnd_message.set_name('EGO','EGO_ASSOC_NO_SUPPL_ACCESS_PRIV');

Line 1487: fnd_message.set_name('EGO','EGO_ASSOC_NO_EDIT_ASSOC_PRIV');

1483: */
1484: ELSIF l_err_rec.process_flag = G_REC_NO_CREATE_ASSOC_PRIV THEN
1485: fnd_message.set_name('EGO','EGO_ASSOC_NO_CREATE_ASSOC_PRIV');
1486: ELSIF l_err_rec.process_flag = G_REC_NO_EDIT_ASSOC_PRIV THEN
1487: fnd_message.set_name('EGO','EGO_ASSOC_NO_EDIT_ASSOC_PRIV');
1488: ELSIF l_err_rec.process_flag = G_REC_NO_SUPPL_ACCESS_PRIV THEN
1489: fnd_message.set_name('EGO','EGO_ASSOC_NO_SUPPL_ACCESS_PRIV');
1490: ELSIF l_err_rec.process_flag = G_REC_SUPPLIER_NOT_ASSIGNED THEN
1491: fnd_message.set_name('EGO','EGO_ASSOC_SUPPL_NOT_ASSIGNED');

Line 1489: fnd_message.set_name('EGO','EGO_ASSOC_NO_SUPPL_ACCESS_PRIV');

1485: fnd_message.set_name('EGO','EGO_ASSOC_NO_CREATE_ASSOC_PRIV');
1486: ELSIF l_err_rec.process_flag = G_REC_NO_EDIT_ASSOC_PRIV THEN
1487: fnd_message.set_name('EGO','EGO_ASSOC_NO_EDIT_ASSOC_PRIV');
1488: ELSIF l_err_rec.process_flag = G_REC_NO_SUPPL_ACCESS_PRIV THEN
1489: fnd_message.set_name('EGO','EGO_ASSOC_NO_SUPPL_ACCESS_PRIV');
1490: ELSIF l_err_rec.process_flag = G_REC_SUPPLIER_NOT_ASSIGNED THEN
1491: fnd_message.set_name('EGO','EGO_ASSOC_SUPPL_NOT_ASSIGNED');
1492: ELSIF l_err_rec.process_flag = G_REC_SITE_NOT_ASSIGNED THEN
1493: fnd_message.set_name('EGO','EGO_ASSOC_SITE_NOT_ASSIGNED');

Line 1491: fnd_message.set_name('EGO','EGO_ASSOC_SUPPL_NOT_ASSIGNED');

1487: fnd_message.set_name('EGO','EGO_ASSOC_NO_EDIT_ASSOC_PRIV');
1488: ELSIF l_err_rec.process_flag = G_REC_NO_SUPPL_ACCESS_PRIV THEN
1489: fnd_message.set_name('EGO','EGO_ASSOC_NO_SUPPL_ACCESS_PRIV');
1490: ELSIF l_err_rec.process_flag = G_REC_SUPPLIER_NOT_ASSIGNED THEN
1491: fnd_message.set_name('EGO','EGO_ASSOC_SUPPL_NOT_ASSIGNED');
1492: ELSIF l_err_rec.process_flag = G_REC_SITE_NOT_ASSIGNED THEN
1493: fnd_message.set_name('EGO','EGO_ASSOC_SITE_NOT_ASSIGNED');
1494: ELSIF l_err_rec.process_flag = G_REC_NO_EDIT_ITEM_ORG_PRIV THEN
1495: fnd_message.set_name('EGO','EGO_ASSOC_NO_EDIT_ITEMORG_PRIV');

Line 1493: fnd_message.set_name('EGO','EGO_ASSOC_SITE_NOT_ASSIGNED');

1489: fnd_message.set_name('EGO','EGO_ASSOC_NO_SUPPL_ACCESS_PRIV');
1490: ELSIF l_err_rec.process_flag = G_REC_SUPPLIER_NOT_ASSIGNED THEN
1491: fnd_message.set_name('EGO','EGO_ASSOC_SUPPL_NOT_ASSIGNED');
1492: ELSIF l_err_rec.process_flag = G_REC_SITE_NOT_ASSIGNED THEN
1493: fnd_message.set_name('EGO','EGO_ASSOC_SITE_NOT_ASSIGNED');
1494: ELSIF l_err_rec.process_flag = G_REC_NO_EDIT_ITEM_ORG_PRIV THEN
1495: fnd_message.set_name('EGO','EGO_ASSOC_NO_EDIT_ITEMORG_PRIV');
1496: /*
1497: ELSIF l_err_rec.process_flag = G_REC_DUPLICATE_PRIMARY THEN

Line 1495: fnd_message.set_name('EGO','EGO_ASSOC_NO_EDIT_ITEMORG_PRIV');

1491: fnd_message.set_name('EGO','EGO_ASSOC_SUPPL_NOT_ASSIGNED');
1492: ELSIF l_err_rec.process_flag = G_REC_SITE_NOT_ASSIGNED THEN
1493: fnd_message.set_name('EGO','EGO_ASSOC_SITE_NOT_ASSIGNED');
1494: ELSIF l_err_rec.process_flag = G_REC_NO_EDIT_ITEM_ORG_PRIV THEN
1495: fnd_message.set_name('EGO','EGO_ASSOC_NO_EDIT_ITEMORG_PRIV');
1496: /*
1497: ELSIF l_err_rec.process_flag = G_REC_DUPLICATE_PRIMARY THEN
1498: fnd_message.set_name('EGO','EGO_ASSOC_DUPLICATE_PRIMARY');
1499: fnd_message.set_token('TRANSACTION_ID',l_err_rec.transaction_id);

Line 1498: fnd_message.set_name('EGO','EGO_ASSOC_DUPLICATE_PRIMARY');

1494: ELSIF l_err_rec.process_flag = G_REC_NO_EDIT_ITEM_ORG_PRIV THEN
1495: fnd_message.set_name('EGO','EGO_ASSOC_NO_EDIT_ITEMORG_PRIV');
1496: /*
1497: ELSIF l_err_rec.process_flag = G_REC_DUPLICATE_PRIMARY THEN
1498: fnd_message.set_name('EGO','EGO_ASSOC_DUPLICATE_PRIMARY');
1499: fnd_message.set_token('TRANSACTION_ID',l_err_rec.transaction_id);
1500: fnd_message.set_token('PK1_VALUE',l_err_rec.pk1_value);
1501: fnd_message.set_token('PK2_VALUE',l_err_rec.pk2_value);
1502: */

Line 1499: fnd_message.set_token('TRANSACTION_ID',l_err_rec.transaction_id);

1495: fnd_message.set_name('EGO','EGO_ASSOC_NO_EDIT_ITEMORG_PRIV');
1496: /*
1497: ELSIF l_err_rec.process_flag = G_REC_DUPLICATE_PRIMARY THEN
1498: fnd_message.set_name('EGO','EGO_ASSOC_DUPLICATE_PRIMARY');
1499: fnd_message.set_token('TRANSACTION_ID',l_err_rec.transaction_id);
1500: fnd_message.set_token('PK1_VALUE',l_err_rec.pk1_value);
1501: fnd_message.set_token('PK2_VALUE',l_err_rec.pk2_value);
1502: */
1503: END IF;

Line 1500: fnd_message.set_token('PK1_VALUE',l_err_rec.pk1_value);

1496: /*
1497: ELSIF l_err_rec.process_flag = G_REC_DUPLICATE_PRIMARY THEN
1498: fnd_message.set_name('EGO','EGO_ASSOC_DUPLICATE_PRIMARY');
1499: fnd_message.set_token('TRANSACTION_ID',l_err_rec.transaction_id);
1500: fnd_message.set_token('PK1_VALUE',l_err_rec.pk1_value);
1501: fnd_message.set_token('PK2_VALUE',l_err_rec.pk2_value);
1502: */
1503: END IF;
1504: l_err_msg := l_err_rec.user_data_level_name || ':::'||l_err_rec.supplier_name||':::';

Line 1501: fnd_message.set_token('PK2_VALUE',l_err_rec.pk2_value);

1497: ELSIF l_err_rec.process_flag = G_REC_DUPLICATE_PRIMARY THEN
1498: fnd_message.set_name('EGO','EGO_ASSOC_DUPLICATE_PRIMARY');
1499: fnd_message.set_token('TRANSACTION_ID',l_err_rec.transaction_id);
1500: fnd_message.set_token('PK1_VALUE',l_err_rec.pk1_value);
1501: fnd_message.set_token('PK2_VALUE',l_err_rec.pk2_value);
1502: */
1503: END IF;
1504: l_err_msg := l_err_rec.user_data_level_name || ':::'||l_err_rec.supplier_name||':::';
1505: IF l_err_rec.data_level_name <> G_ITEM_SUP_LEVEL_NAME THEN

Line 1508: l_err_msg := l_err_msg||fnd_message.get();

1504: l_err_msg := l_err_rec.user_data_level_name || ':::'||l_err_rec.supplier_name||':::';
1505: IF l_err_rec.data_level_name <> G_ITEM_SUP_LEVEL_NAME THEN
1506: l_err_msg := l_err_msg || l_err_rec.supplier_site_name || ':::';
1507: END IF;
1508: l_err_msg := l_err_msg||fnd_message.get();
1509: fnd_msg_pub.add;
1510: INSERT INTO mtl_interface_errors
1511: ( transaction_id
1512: , organization_id