DBA Data[Home] [Help]

APPS.JTF_UM_USERTYPE_CREDENTIALS dependencies on FND_MESSAGE

Line 1588: fnd_message.set_name('JTF','JTA_UM_PRI_UP_USER_HEADER');

1584: END IF;
1585: CLOSE FIND_BUS_UT_ID;
1586:
1587:
1588: fnd_message.set_name('JTF','JTA_UM_PRI_UP_USER_HEADER');
1589: fnd_file.new_line(fnd_file.log,1);
1590: fnd_file.put_line(fnd_file.log, fnd_message.get);
1591:
1592: IF RETCODE = FND_API.G_RET_STS_SUCCESS THEN

Line 1590: fnd_file.put_line(fnd_file.log, fnd_message.get);

1586:
1587:
1588: fnd_message.set_name('JTF','JTA_UM_PRI_UP_USER_HEADER');
1589: fnd_file.new_line(fnd_file.log,1);
1590: fnd_file.put_line(fnd_file.log, fnd_message.get);
1591:
1592: IF RETCODE = FND_API.G_RET_STS_SUCCESS THEN
1593:
1594: FOR i IN PRIMARY_USERS LOOP

Line 1595: fnd_message.set_name('JTF','JTA_UM_PRI_UP_USERS');

1591:
1592: IF RETCODE = FND_API.G_RET_STS_SUCCESS THEN
1593:
1594: FOR i IN PRIMARY_USERS LOOP
1595: fnd_message.set_name('JTF','JTA_UM_PRI_UP_USERS');
1596: UPDATE JTF_UM_USERTYPE_REG SET USERTYPE_ID = l_new_usertype_id
1597: WHERE USERTYPE_REG_ID = i.USERTYPE_REG_ID;
1598:
1599: COMMIT;

Line 1614: fnd_message.set_token( 'USER_NAME', l_user_name );

1610: AND NVL(R.END_DATE, SYSDATE + 1) > SYSDATE
1611: and f.user_id = i.user_id
1612: and r.relationship_code='EMPLOYEE_OF';
1613:
1614: fnd_message.set_token( 'USER_NAME', l_user_name );
1615: fnd_message.set_token( 'ORG_NAME', l_org_name );
1616: fnd_message.set_token( 'EMAIL', l_email );
1617: fnd_file.put_line(fnd_file.log, fnd_message.get);
1618: EXCEPTION

Line 1615: fnd_message.set_token( 'ORG_NAME', l_org_name );

1611: and f.user_id = i.user_id
1612: and r.relationship_code='EMPLOYEE_OF';
1613:
1614: fnd_message.set_token( 'USER_NAME', l_user_name );
1615: fnd_message.set_token( 'ORG_NAME', l_org_name );
1616: fnd_message.set_token( 'EMAIL', l_email );
1617: fnd_file.put_line(fnd_file.log, fnd_message.get);
1618: EXCEPTION
1619: WHEN OTHERS THEN

Line 1616: fnd_message.set_token( 'EMAIL', l_email );

1612: and r.relationship_code='EMPLOYEE_OF';
1613:
1614: fnd_message.set_token( 'USER_NAME', l_user_name );
1615: fnd_message.set_token( 'ORG_NAME', l_org_name );
1616: fnd_message.set_token( 'EMAIL', l_email );
1617: fnd_file.put_line(fnd_file.log, fnd_message.get);
1618: EXCEPTION
1619: WHEN OTHERS THEN
1620: fnd_message.set_token( 'USER_NAME', i.user_id );

Line 1617: fnd_file.put_line(fnd_file.log, fnd_message.get);

1613:
1614: fnd_message.set_token( 'USER_NAME', l_user_name );
1615: fnd_message.set_token( 'ORG_NAME', l_org_name );
1616: fnd_message.set_token( 'EMAIL', l_email );
1617: fnd_file.put_line(fnd_file.log, fnd_message.get);
1618: EXCEPTION
1619: WHEN OTHERS THEN
1620: fnd_message.set_token( 'USER_NAME', i.user_id );
1621: fnd_message.set_token( 'ORG_NAME', 'Could not be retrived' );

Line 1620: fnd_message.set_token( 'USER_NAME', i.user_id );

1616: fnd_message.set_token( 'EMAIL', l_email );
1617: fnd_file.put_line(fnd_file.log, fnd_message.get);
1618: EXCEPTION
1619: WHEN OTHERS THEN
1620: fnd_message.set_token( 'USER_NAME', i.user_id );
1621: fnd_message.set_token( 'ORG_NAME', 'Could not be retrived' );
1622: fnd_message.set_token( 'EMAIL', 'Could not be retrived' );
1623: fnd_file.put_line(fnd_file.log, fnd_message.get);
1624: END;

Line 1621: fnd_message.set_token( 'ORG_NAME', 'Could not be retrived' );

1617: fnd_file.put_line(fnd_file.log, fnd_message.get);
1618: EXCEPTION
1619: WHEN OTHERS THEN
1620: fnd_message.set_token( 'USER_NAME', i.user_id );
1621: fnd_message.set_token( 'ORG_NAME', 'Could not be retrived' );
1622: fnd_message.set_token( 'EMAIL', 'Could not be retrived' );
1623: fnd_file.put_line(fnd_file.log, fnd_message.get);
1624: END;
1625: END LOOP;

Line 1622: fnd_message.set_token( 'EMAIL', 'Could not be retrived' );

1618: EXCEPTION
1619: WHEN OTHERS THEN
1620: fnd_message.set_token( 'USER_NAME', i.user_id );
1621: fnd_message.set_token( 'ORG_NAME', 'Could not be retrived' );
1622: fnd_message.set_token( 'EMAIL', 'Could not be retrived' );
1623: fnd_file.put_line(fnd_file.log, fnd_message.get);
1624: END;
1625: END LOOP;
1626:

Line 1623: fnd_file.put_line(fnd_file.log, fnd_message.get);

1619: WHEN OTHERS THEN
1620: fnd_message.set_token( 'USER_NAME', i.user_id );
1621: fnd_message.set_token( 'ORG_NAME', 'Could not be retrived' );
1622: fnd_message.set_token( 'EMAIL', 'Could not be retrived' );
1623: fnd_file.put_line(fnd_file.log, fnd_message.get);
1624: END;
1625: END LOOP;
1626:
1627: END IF;

Line 1629: fnd_message.set_name('JTF','JTA_UM_PENDING_USER_HEADER');

1625: END LOOP;
1626:
1627: END IF;
1628:
1629: fnd_message.set_name('JTF','JTA_UM_PENDING_USER_HEADER');
1630: fnd_file.new_line(fnd_file.log,1);
1631: fnd_file.put_line(fnd_file.log, fnd_message.get);
1632:
1633: FOR i IN PENDING_USERS LOOP

Line 1631: fnd_file.put_line(fnd_file.log, fnd_message.get);

1627: END IF;
1628:
1629: fnd_message.set_name('JTF','JTA_UM_PENDING_USER_HEADER');
1630: fnd_file.new_line(fnd_file.log,1);
1631: fnd_file.put_line(fnd_file.log, fnd_message.get);
1632:
1633: FOR i IN PENDING_USERS LOOP
1634: fnd_message.set_name('JTF','JTA_UM_PENDING_USERS');
1635: fnd_message.set_token( 'USER_NAME', i.user_name );

Line 1634: fnd_message.set_name('JTF','JTA_UM_PENDING_USERS');

1630: fnd_file.new_line(fnd_file.log,1);
1631: fnd_file.put_line(fnd_file.log, fnd_message.get);
1632:
1633: FOR i IN PENDING_USERS LOOP
1634: fnd_message.set_name('JTF','JTA_UM_PENDING_USERS');
1635: fnd_message.set_token( 'USER_NAME', i.user_name );
1636: fnd_message.set_token( 'ORG_NAME', i.party_name );
1637: fnd_message.set_token( 'EMAIL', i.email_address );
1638: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 1635: fnd_message.set_token( 'USER_NAME', i.user_name );

1631: fnd_file.put_line(fnd_file.log, fnd_message.get);
1632:
1633: FOR i IN PENDING_USERS LOOP
1634: fnd_message.set_name('JTF','JTA_UM_PENDING_USERS');
1635: fnd_message.set_token( 'USER_NAME', i.user_name );
1636: fnd_message.set_token( 'ORG_NAME', i.party_name );
1637: fnd_message.set_token( 'EMAIL', i.email_address );
1638: fnd_file.put_line(fnd_file.log, fnd_message.get);
1639: l_pending_users := l_pending_users + 1;

Line 1636: fnd_message.set_token( 'ORG_NAME', i.party_name );

1632:
1633: FOR i IN PENDING_USERS LOOP
1634: fnd_message.set_name('JTF','JTA_UM_PENDING_USERS');
1635: fnd_message.set_token( 'USER_NAME', i.user_name );
1636: fnd_message.set_token( 'ORG_NAME', i.party_name );
1637: fnd_message.set_token( 'EMAIL', i.email_address );
1638: fnd_file.put_line(fnd_file.log, fnd_message.get);
1639: l_pending_users := l_pending_users + 1;
1640: END LOOP;

Line 1637: fnd_message.set_token( 'EMAIL', i.email_address );

1633: FOR i IN PENDING_USERS LOOP
1634: fnd_message.set_name('JTF','JTA_UM_PENDING_USERS');
1635: fnd_message.set_token( 'USER_NAME', i.user_name );
1636: fnd_message.set_token( 'ORG_NAME', i.party_name );
1637: fnd_message.set_token( 'EMAIL', i.email_address );
1638: fnd_file.put_line(fnd_file.log, fnd_message.get);
1639: l_pending_users := l_pending_users + 1;
1640: END LOOP;
1641:

Line 1638: fnd_file.put_line(fnd_file.log, fnd_message.get);

1634: fnd_message.set_name('JTF','JTA_UM_PENDING_USERS');
1635: fnd_message.set_token( 'USER_NAME', i.user_name );
1636: fnd_message.set_token( 'ORG_NAME', i.party_name );
1637: fnd_message.set_token( 'EMAIL', i.email_address );
1638: fnd_file.put_line(fnd_file.log, fnd_message.get);
1639: l_pending_users := l_pending_users + 1;
1640: END LOOP;
1641:
1642: fnd_file.new_line(fnd_file.log,1);

Line 1651: fnd_message.set_name('JTF','JTA_UM_PRI_UP_COMPLETE');

1647: AND UT.USERTYPE_ID = UTREG.USERTYPE_ID
1648: AND UTREG.STATUS_CODE = 'PENDING';
1649: */
1650: IF l_pending_users = 0 THEN
1651: fnd_message.set_name('JTF','JTA_UM_PRI_UP_COMPLETE');
1652: ELSE
1653: fnd_message.set_name('JTF','JTA_UM_PRI_UP_INCOMPLETE');
1654: fnd_message.set_token('USERS',l_pending_users);
1655: END IF;

Line 1653: fnd_message.set_name('JTF','JTA_UM_PRI_UP_INCOMPLETE');

1649: */
1650: IF l_pending_users = 0 THEN
1651: fnd_message.set_name('JTF','JTA_UM_PRI_UP_COMPLETE');
1652: ELSE
1653: fnd_message.set_name('JTF','JTA_UM_PRI_UP_INCOMPLETE');
1654: fnd_message.set_token('USERS',l_pending_users);
1655: END IF;
1656:
1657: fnd_file.new_line(fnd_file.log,1);

Line 1654: fnd_message.set_token('USERS',l_pending_users);

1650: IF l_pending_users = 0 THEN
1651: fnd_message.set_name('JTF','JTA_UM_PRI_UP_COMPLETE');
1652: ELSE
1653: fnd_message.set_name('JTF','JTA_UM_PRI_UP_INCOMPLETE');
1654: fnd_message.set_token('USERS',l_pending_users);
1655: END IF;
1656:
1657: fnd_file.new_line(fnd_file.log,1);
1658: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 1658: fnd_file.put_line(fnd_file.log, fnd_message.get);

1654: fnd_message.set_token('USERS',l_pending_users);
1655: END IF;
1656:
1657: fnd_file.new_line(fnd_file.log,1);
1658: fnd_file.put_line(fnd_file.log, fnd_message.get);
1659:
1660: END UPGRADE_PRIMARY_USER;
1661: END JTF_UM_USERTYPE_CREDENTIALS;