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 464: l_msg_data := FND_MESSAGE.GET_ENCODED();

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1375: BEGIN
1376: FOR l_err_rec IN l_err_rows_csr(p_batch_id)
1377: LOOP
1378: IF l_err_rec.process_flag = G_REC_MISSING_REQ_VALUE THEN
1379: fnd_message.set_name('EGO','EGO_ASSOC_MISSING_REQ_VALUE');
1380: ELSIF l_err_rec.process_flag = G_REC_INVALID_TRAN_TYPE THEN
1381: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_TRAN_TYPE');
1382: ELSIF l_err_rec.process_flag = G_REC_INVALID_MASTER_ORG THEN
1383: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_MASTER_ORG');

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

1377: LOOP
1378: IF l_err_rec.process_flag = G_REC_MISSING_REQ_VALUE THEN
1379: fnd_message.set_name('EGO','EGO_ASSOC_MISSING_REQ_VALUE');
1380: ELSIF l_err_rec.process_flag = G_REC_INVALID_TRAN_TYPE THEN
1381: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_TRAN_TYPE');
1382: ELSIF l_err_rec.process_flag = G_REC_INVALID_MASTER_ORG THEN
1383: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_MASTER_ORG');
1384: ELSIF l_err_rec.process_flag = G_REC_INVALID_ORG THEN
1385: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_ORG');

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

1379: fnd_message.set_name('EGO','EGO_ASSOC_MISSING_REQ_VALUE');
1380: ELSIF l_err_rec.process_flag = G_REC_INVALID_TRAN_TYPE THEN
1381: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_TRAN_TYPE');
1382: ELSIF l_err_rec.process_flag = G_REC_INVALID_MASTER_ORG THEN
1383: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_MASTER_ORG');
1384: ELSIF l_err_rec.process_flag = G_REC_INVALID_ORG THEN
1385: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_ORG');
1386: ELSIF l_err_rec.process_flag = G_REC_INVALID_ITEM THEN
1387: fnd_message.set_name('EGO','EGO_ASSOC_ITEM_NOT_IN_ORG');

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

1381: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_TRAN_TYPE');
1382: ELSIF l_err_rec.process_flag = G_REC_INVALID_MASTER_ORG THEN
1383: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_MASTER_ORG');
1384: ELSIF l_err_rec.process_flag = G_REC_INVALID_ORG THEN
1385: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_ORG');
1386: ELSIF l_err_rec.process_flag = G_REC_INVALID_ITEM THEN
1387: fnd_message.set_name('EGO','EGO_ASSOC_ITEM_NOT_IN_ORG');
1388: ELSIF l_err_rec.process_flag = G_REC_INVALID_PK1_VALUE THEN
1389: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_PK1_VALUE');

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

1383: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_MASTER_ORG');
1384: ELSIF l_err_rec.process_flag = G_REC_INVALID_ORG THEN
1385: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_ORG');
1386: ELSIF l_err_rec.process_flag = G_REC_INVALID_ITEM THEN
1387: fnd_message.set_name('EGO','EGO_ASSOC_ITEM_NOT_IN_ORG');
1388: ELSIF l_err_rec.process_flag = G_REC_INVALID_PK1_VALUE THEN
1389: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_PK1_VALUE');
1390: ELSIF l_err_rec.process_flag = G_REC_INVALID_PK2_VALUE THEN
1391: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_PK2_VALUE');

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

1385: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_ORG');
1386: ELSIF l_err_rec.process_flag = G_REC_INVALID_ITEM THEN
1387: fnd_message.set_name('EGO','EGO_ASSOC_ITEM_NOT_IN_ORG');
1388: ELSIF l_err_rec.process_flag = G_REC_INVALID_PK1_VALUE THEN
1389: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_PK1_VALUE');
1390: ELSIF l_err_rec.process_flag = G_REC_INVALID_PK2_VALUE THEN
1391: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_PK2_VALUE');
1392: ELSIF l_err_rec.process_flag = G_REC_INVALID_ASSOC_TYPE THEN
1393: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_ASSOC_TYPE');

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

1387: fnd_message.set_name('EGO','EGO_ASSOC_ITEM_NOT_IN_ORG');
1388: ELSIF l_err_rec.process_flag = G_REC_INVALID_PK1_VALUE THEN
1389: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_PK1_VALUE');
1390: ELSIF l_err_rec.process_flag = G_REC_INVALID_PK2_VALUE THEN
1391: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_PK2_VALUE');
1392: ELSIF l_err_rec.process_flag = G_REC_INVALID_ASSOC_TYPE THEN
1393: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_ASSOC_TYPE');
1394: ELSIF l_err_rec.process_flag = G_REC_INVALID_STATUS THEN
1395: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_STATUS');

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

1389: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_PK1_VALUE');
1390: ELSIF l_err_rec.process_flag = G_REC_INVALID_PK2_VALUE THEN
1391: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_PK2_VALUE');
1392: ELSIF l_err_rec.process_flag = G_REC_INVALID_ASSOC_TYPE THEN
1393: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_ASSOC_TYPE');
1394: ELSIF l_err_rec.process_flag = G_REC_INVALID_STATUS THEN
1395: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_STATUS');
1396: ELSIF l_err_rec.process_flag = G_REC_INVALID_PRIMARY THEN
1397: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_PRIMARY');

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

1391: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_PK2_VALUE');
1392: ELSIF l_err_rec.process_flag = G_REC_INVALID_ASSOC_TYPE THEN
1393: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_ASSOC_TYPE');
1394: ELSIF l_err_rec.process_flag = G_REC_INVALID_STATUS THEN
1395: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_STATUS');
1396: ELSIF l_err_rec.process_flag = G_REC_INVALID_PRIMARY THEN
1397: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_PRIMARY');
1398: ELSIF l_err_rec.process_flag = G_REC_ASSOCIATION_NOT_EXISTS THEN
1399: fnd_message.set_name('EGO','EGO_ASSOC_NOT_EXISTS');

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

1393: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_ASSOC_TYPE');
1394: ELSIF l_err_rec.process_flag = G_REC_INVALID_STATUS THEN
1395: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_STATUS');
1396: ELSIF l_err_rec.process_flag = G_REC_INVALID_PRIMARY THEN
1397: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_PRIMARY');
1398: ELSIF l_err_rec.process_flag = G_REC_ASSOCIATION_NOT_EXISTS THEN
1399: fnd_message.set_name('EGO','EGO_ASSOC_NOT_EXISTS');
1400: ELSIF l_err_rec.process_flag = G_REC_ALREADY_ASSIGNED THEN
1401: fnd_message.set_name('EGO','EGO_ASSOC_ALREADY_ASSIGNED');

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

1395: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_STATUS');
1396: ELSIF l_err_rec.process_flag = G_REC_INVALID_PRIMARY THEN
1397: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_PRIMARY');
1398: ELSIF l_err_rec.process_flag = G_REC_ASSOCIATION_NOT_EXISTS THEN
1399: fnd_message.set_name('EGO','EGO_ASSOC_NOT_EXISTS');
1400: ELSIF l_err_rec.process_flag = G_REC_ALREADY_ASSIGNED THEN
1401: fnd_message.set_name('EGO','EGO_ASSOC_ALREADY_ASSIGNED');
1402: ELSIF l_err_rec.process_flag = G_REC_ASSOC_SITE_NOT_EXISTS THEN
1403: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_PK2_VALUE');

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

1397: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_PRIMARY');
1398: ELSIF l_err_rec.process_flag = G_REC_ASSOCIATION_NOT_EXISTS THEN
1399: fnd_message.set_name('EGO','EGO_ASSOC_NOT_EXISTS');
1400: ELSIF l_err_rec.process_flag = G_REC_ALREADY_ASSIGNED THEN
1401: fnd_message.set_name('EGO','EGO_ASSOC_ALREADY_ASSIGNED');
1402: ELSIF l_err_rec.process_flag = G_REC_ASSOC_SITE_NOT_EXISTS THEN
1403: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_PK2_VALUE');
1404: ELSIF l_err_rec.process_flag = G_REC_ASSOC_ITEM_NOT_IN_ORG THEN
1405: fnd_message.set_name('EGO','EGO_ASSOC_ITEM_NOT_IN_ORG');

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

1399: fnd_message.set_name('EGO','EGO_ASSOC_NOT_EXISTS');
1400: ELSIF l_err_rec.process_flag = G_REC_ALREADY_ASSIGNED THEN
1401: fnd_message.set_name('EGO','EGO_ASSOC_ALREADY_ASSIGNED');
1402: ELSIF l_err_rec.process_flag = G_REC_ASSOC_SITE_NOT_EXISTS THEN
1403: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_PK2_VALUE');
1404: ELSIF l_err_rec.process_flag = G_REC_ASSOC_ITEM_NOT_IN_ORG THEN
1405: fnd_message.set_name('EGO','EGO_ASSOC_ITEM_NOT_IN_ORG');
1406: ELSIF l_err_rec.process_flag = G_REC_PARENT_NOT_ASSIGNED THEN
1407: fnd_message.set_name('EGO','EGO_ASSOC_PARENT_NOT_ASSIGNED');

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

1401: fnd_message.set_name('EGO','EGO_ASSOC_ALREADY_ASSIGNED');
1402: ELSIF l_err_rec.process_flag = G_REC_ASSOC_SITE_NOT_EXISTS THEN
1403: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_PK2_VALUE');
1404: ELSIF l_err_rec.process_flag = G_REC_ASSOC_ITEM_NOT_IN_ORG THEN
1405: fnd_message.set_name('EGO','EGO_ASSOC_ITEM_NOT_IN_ORG');
1406: ELSIF l_err_rec.process_flag = G_REC_PARENT_NOT_ASSIGNED THEN
1407: fnd_message.set_name('EGO','EGO_ASSOC_PARENT_NOT_ASSIGNED');
1408: ELSIF l_err_rec.process_flag = G_REC_PARENT_NOT_ACTIVE THEN
1409: fnd_message.set_name('EGO','EGO_ASSOC_PARENT_NOT_ACTIVE');

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

1403: fnd_message.set_name('EGO','EGO_ASSOC_INVALID_PK2_VALUE');
1404: ELSIF l_err_rec.process_flag = G_REC_ASSOC_ITEM_NOT_IN_ORG THEN
1405: fnd_message.set_name('EGO','EGO_ASSOC_ITEM_NOT_IN_ORG');
1406: ELSIF l_err_rec.process_flag = G_REC_PARENT_NOT_ASSIGNED THEN
1407: fnd_message.set_name('EGO','EGO_ASSOC_PARENT_NOT_ASSIGNED');
1408: ELSIF l_err_rec.process_flag = G_REC_PARENT_NOT_ACTIVE THEN
1409: fnd_message.set_name('EGO','EGO_ASSOC_PARENT_NOT_ACTIVE');
1410: ELSIF l_err_rec.process_flag = G_REC_PRIMARY_NOT_ACTIVE THEN
1411: fnd_message.set_name('EGO','EGO_ASSOC_PRIMARY_NOT_ACTIVE');

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

1405: fnd_message.set_name('EGO','EGO_ASSOC_ITEM_NOT_IN_ORG');
1406: ELSIF l_err_rec.process_flag = G_REC_PARENT_NOT_ASSIGNED THEN
1407: fnd_message.set_name('EGO','EGO_ASSOC_PARENT_NOT_ASSIGNED');
1408: ELSIF l_err_rec.process_flag = G_REC_PARENT_NOT_ACTIVE THEN
1409: fnd_message.set_name('EGO','EGO_ASSOC_PARENT_NOT_ACTIVE');
1410: ELSIF l_err_rec.process_flag = G_REC_PRIMARY_NOT_ACTIVE THEN
1411: fnd_message.set_name('EGO','EGO_ASSOC_PRIMARY_NOT_ACTIVE');
1412: /*
1413: ELSIF l_err_rec.process_flag = G_REC_DUPLICATE THEN

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

1407: fnd_message.set_name('EGO','EGO_ASSOC_PARENT_NOT_ASSIGNED');
1408: ELSIF l_err_rec.process_flag = G_REC_PARENT_NOT_ACTIVE THEN
1409: fnd_message.set_name('EGO','EGO_ASSOC_PARENT_NOT_ACTIVE');
1410: ELSIF l_err_rec.process_flag = G_REC_PRIMARY_NOT_ACTIVE THEN
1411: fnd_message.set_name('EGO','EGO_ASSOC_PRIMARY_NOT_ACTIVE');
1412: /*
1413: ELSIF l_err_rec.process_flag = G_REC_DUPLICATE THEN
1414: fnd_message.set_name('EGO','EGO_ASSOC_DUPLICATE');
1415: fnd_message.set_token('TRANSACTION_ID',l_err_rec.transaction_id);

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

1410: ELSIF l_err_rec.process_flag = G_REC_PRIMARY_NOT_ACTIVE THEN
1411: fnd_message.set_name('EGO','EGO_ASSOC_PRIMARY_NOT_ACTIVE');
1412: /*
1413: ELSIF l_err_rec.process_flag = G_REC_DUPLICATE THEN
1414: fnd_message.set_name('EGO','EGO_ASSOC_DUPLICATE');
1415: fnd_message.set_token('TRANSACTION_ID',l_err_rec.transaction_id);
1416: fnd_message.set_token('ITEM_NAME',l_err_rec.item_number);
1417: fnd_message.set_token('ORG_CODE',l_err_rec.organization_code);
1418: fnd_message.set_token('DATA_LEVEL',l_err_rec.data_level_id); -- Do we allow to enter user enterable field

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

1411: fnd_message.set_name('EGO','EGO_ASSOC_PRIMARY_NOT_ACTIVE');
1412: /*
1413: ELSIF l_err_rec.process_flag = G_REC_DUPLICATE THEN
1414: fnd_message.set_name('EGO','EGO_ASSOC_DUPLICATE');
1415: fnd_message.set_token('TRANSACTION_ID',l_err_rec.transaction_id);
1416: fnd_message.set_token('ITEM_NAME',l_err_rec.item_number);
1417: fnd_message.set_token('ORG_CODE',l_err_rec.organization_code);
1418: fnd_message.set_token('DATA_LEVEL',l_err_rec.data_level_id); -- Do we allow to enter user enterable field
1419: */

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

1412: /*
1413: ELSIF l_err_rec.process_flag = G_REC_DUPLICATE THEN
1414: fnd_message.set_name('EGO','EGO_ASSOC_DUPLICATE');
1415: fnd_message.set_token('TRANSACTION_ID',l_err_rec.transaction_id);
1416: fnd_message.set_token('ITEM_NAME',l_err_rec.item_number);
1417: fnd_message.set_token('ORG_CODE',l_err_rec.organization_code);
1418: fnd_message.set_token('DATA_LEVEL',l_err_rec.data_level_id); -- Do we allow to enter user enterable field
1419: */
1420: ELSIF l_err_rec.process_flag = G_REC_NO_CREATE_ASSOC_PRIV THEN

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

1413: ELSIF l_err_rec.process_flag = G_REC_DUPLICATE THEN
1414: fnd_message.set_name('EGO','EGO_ASSOC_DUPLICATE');
1415: fnd_message.set_token('TRANSACTION_ID',l_err_rec.transaction_id);
1416: fnd_message.set_token('ITEM_NAME',l_err_rec.item_number);
1417: fnd_message.set_token('ORG_CODE',l_err_rec.organization_code);
1418: fnd_message.set_token('DATA_LEVEL',l_err_rec.data_level_id); -- Do we allow to enter user enterable field
1419: */
1420: ELSIF l_err_rec.process_flag = G_REC_NO_CREATE_ASSOC_PRIV THEN
1421: fnd_message.set_name('EGO','EGO_ASSOC_NO_CREATE_ASSOC_PRIV');

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

1414: fnd_message.set_name('EGO','EGO_ASSOC_DUPLICATE');
1415: fnd_message.set_token('TRANSACTION_ID',l_err_rec.transaction_id);
1416: fnd_message.set_token('ITEM_NAME',l_err_rec.item_number);
1417: fnd_message.set_token('ORG_CODE',l_err_rec.organization_code);
1418: fnd_message.set_token('DATA_LEVEL',l_err_rec.data_level_id); -- Do we allow to enter user enterable field
1419: */
1420: ELSIF l_err_rec.process_flag = G_REC_NO_CREATE_ASSOC_PRIV THEN
1421: fnd_message.set_name('EGO','EGO_ASSOC_NO_CREATE_ASSOC_PRIV');
1422: ELSIF l_err_rec.process_flag = G_REC_NO_EDIT_ASSOC_PRIV THEN

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

1417: fnd_message.set_token('ORG_CODE',l_err_rec.organization_code);
1418: fnd_message.set_token('DATA_LEVEL',l_err_rec.data_level_id); -- Do we allow to enter user enterable field
1419: */
1420: ELSIF l_err_rec.process_flag = G_REC_NO_CREATE_ASSOC_PRIV THEN
1421: fnd_message.set_name('EGO','EGO_ASSOC_NO_CREATE_ASSOC_PRIV');
1422: ELSIF l_err_rec.process_flag = G_REC_NO_EDIT_ASSOC_PRIV THEN
1423: fnd_message.set_name('EGO','EGO_ASSOC_NO_EDIT_ASSOC_PRIV');
1424: ELSIF l_err_rec.process_flag = G_REC_NO_SUPPL_ACCESS_PRIV THEN
1425: fnd_message.set_name('EGO','EGO_ASSOC_NO_SUPPL_ACCESS_PRIV');

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

1419: */
1420: ELSIF l_err_rec.process_flag = G_REC_NO_CREATE_ASSOC_PRIV THEN
1421: fnd_message.set_name('EGO','EGO_ASSOC_NO_CREATE_ASSOC_PRIV');
1422: ELSIF l_err_rec.process_flag = G_REC_NO_EDIT_ASSOC_PRIV THEN
1423: fnd_message.set_name('EGO','EGO_ASSOC_NO_EDIT_ASSOC_PRIV');
1424: ELSIF l_err_rec.process_flag = G_REC_NO_SUPPL_ACCESS_PRIV THEN
1425: fnd_message.set_name('EGO','EGO_ASSOC_NO_SUPPL_ACCESS_PRIV');
1426: ELSIF l_err_rec.process_flag = G_REC_SUPPLIER_NOT_ASSIGNED THEN
1427: fnd_message.set_name('EGO','EGO_ASSOC_SUPPL_NOT_ASSIGNED');

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

1421: fnd_message.set_name('EGO','EGO_ASSOC_NO_CREATE_ASSOC_PRIV');
1422: ELSIF l_err_rec.process_flag = G_REC_NO_EDIT_ASSOC_PRIV THEN
1423: fnd_message.set_name('EGO','EGO_ASSOC_NO_EDIT_ASSOC_PRIV');
1424: ELSIF l_err_rec.process_flag = G_REC_NO_SUPPL_ACCESS_PRIV THEN
1425: fnd_message.set_name('EGO','EGO_ASSOC_NO_SUPPL_ACCESS_PRIV');
1426: ELSIF l_err_rec.process_flag = G_REC_SUPPLIER_NOT_ASSIGNED THEN
1427: fnd_message.set_name('EGO','EGO_ASSOC_SUPPL_NOT_ASSIGNED');
1428: ELSIF l_err_rec.process_flag = G_REC_SITE_NOT_ASSIGNED THEN
1429: fnd_message.set_name('EGO','EGO_ASSOC_SITE_NOT_ASSIGNED');

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

1423: fnd_message.set_name('EGO','EGO_ASSOC_NO_EDIT_ASSOC_PRIV');
1424: ELSIF l_err_rec.process_flag = G_REC_NO_SUPPL_ACCESS_PRIV THEN
1425: fnd_message.set_name('EGO','EGO_ASSOC_NO_SUPPL_ACCESS_PRIV');
1426: ELSIF l_err_rec.process_flag = G_REC_SUPPLIER_NOT_ASSIGNED THEN
1427: fnd_message.set_name('EGO','EGO_ASSOC_SUPPL_NOT_ASSIGNED');
1428: ELSIF l_err_rec.process_flag = G_REC_SITE_NOT_ASSIGNED THEN
1429: fnd_message.set_name('EGO','EGO_ASSOC_SITE_NOT_ASSIGNED');
1430: ELSIF l_err_rec.process_flag = G_REC_NO_EDIT_ITEM_ORG_PRIV THEN
1431: fnd_message.set_name('EGO','EGO_ASSOC_NO_EDIT_ITEMORG_PRIV');

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

1425: fnd_message.set_name('EGO','EGO_ASSOC_NO_SUPPL_ACCESS_PRIV');
1426: ELSIF l_err_rec.process_flag = G_REC_SUPPLIER_NOT_ASSIGNED THEN
1427: fnd_message.set_name('EGO','EGO_ASSOC_SUPPL_NOT_ASSIGNED');
1428: ELSIF l_err_rec.process_flag = G_REC_SITE_NOT_ASSIGNED THEN
1429: fnd_message.set_name('EGO','EGO_ASSOC_SITE_NOT_ASSIGNED');
1430: ELSIF l_err_rec.process_flag = G_REC_NO_EDIT_ITEM_ORG_PRIV THEN
1431: fnd_message.set_name('EGO','EGO_ASSOC_NO_EDIT_ITEMORG_PRIV');
1432: /*
1433: ELSIF l_err_rec.process_flag = G_REC_DUPLICATE_PRIMARY THEN

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

1427: fnd_message.set_name('EGO','EGO_ASSOC_SUPPL_NOT_ASSIGNED');
1428: ELSIF l_err_rec.process_flag = G_REC_SITE_NOT_ASSIGNED THEN
1429: fnd_message.set_name('EGO','EGO_ASSOC_SITE_NOT_ASSIGNED');
1430: ELSIF l_err_rec.process_flag = G_REC_NO_EDIT_ITEM_ORG_PRIV THEN
1431: fnd_message.set_name('EGO','EGO_ASSOC_NO_EDIT_ITEMORG_PRIV');
1432: /*
1433: ELSIF l_err_rec.process_flag = G_REC_DUPLICATE_PRIMARY THEN
1434: fnd_message.set_name('EGO','EGO_ASSOC_DUPLICATE_PRIMARY');
1435: fnd_message.set_token('TRANSACTION_ID',l_err_rec.transaction_id);

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

1430: ELSIF l_err_rec.process_flag = G_REC_NO_EDIT_ITEM_ORG_PRIV THEN
1431: fnd_message.set_name('EGO','EGO_ASSOC_NO_EDIT_ITEMORG_PRIV');
1432: /*
1433: ELSIF l_err_rec.process_flag = G_REC_DUPLICATE_PRIMARY THEN
1434: fnd_message.set_name('EGO','EGO_ASSOC_DUPLICATE_PRIMARY');
1435: fnd_message.set_token('TRANSACTION_ID',l_err_rec.transaction_id);
1436: fnd_message.set_token('PK1_VALUE',l_err_rec.pk1_value);
1437: fnd_message.set_token('PK2_VALUE',l_err_rec.pk2_value);
1438: */

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

1431: fnd_message.set_name('EGO','EGO_ASSOC_NO_EDIT_ITEMORG_PRIV');
1432: /*
1433: ELSIF l_err_rec.process_flag = G_REC_DUPLICATE_PRIMARY THEN
1434: fnd_message.set_name('EGO','EGO_ASSOC_DUPLICATE_PRIMARY');
1435: fnd_message.set_token('TRANSACTION_ID',l_err_rec.transaction_id);
1436: fnd_message.set_token('PK1_VALUE',l_err_rec.pk1_value);
1437: fnd_message.set_token('PK2_VALUE',l_err_rec.pk2_value);
1438: */
1439: END IF;

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

1432: /*
1433: ELSIF l_err_rec.process_flag = G_REC_DUPLICATE_PRIMARY THEN
1434: fnd_message.set_name('EGO','EGO_ASSOC_DUPLICATE_PRIMARY');
1435: fnd_message.set_token('TRANSACTION_ID',l_err_rec.transaction_id);
1436: fnd_message.set_token('PK1_VALUE',l_err_rec.pk1_value);
1437: fnd_message.set_token('PK2_VALUE',l_err_rec.pk2_value);
1438: */
1439: END IF;
1440: l_err_msg := l_err_rec.user_data_level_name || ':::'||l_err_rec.supplier_name||':::';

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

1433: ELSIF l_err_rec.process_flag = G_REC_DUPLICATE_PRIMARY THEN
1434: fnd_message.set_name('EGO','EGO_ASSOC_DUPLICATE_PRIMARY');
1435: fnd_message.set_token('TRANSACTION_ID',l_err_rec.transaction_id);
1436: fnd_message.set_token('PK1_VALUE',l_err_rec.pk1_value);
1437: fnd_message.set_token('PK2_VALUE',l_err_rec.pk2_value);
1438: */
1439: END IF;
1440: l_err_msg := l_err_rec.user_data_level_name || ':::'||l_err_rec.supplier_name||':::';
1441: IF l_err_rec.data_level_name <> G_ITEM_SUP_LEVEL_NAME THEN

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

1440: l_err_msg := l_err_rec.user_data_level_name || ':::'||l_err_rec.supplier_name||':::';
1441: IF l_err_rec.data_level_name <> G_ITEM_SUP_LEVEL_NAME THEN
1442: l_err_msg := l_err_msg || l_err_rec.supplier_site_name || ':::';
1443: END IF;
1444: l_err_msg := l_err_msg||fnd_message.get();
1445: fnd_msg_pub.add;
1446: INSERT INTO mtl_interface_errors
1447: ( transaction_id
1448: , organization_id