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.IGS_PE_USERID_PKG dependencies on IGS_PE_USERID_PKG

Line 1: PACKAGE BODY IGS_PE_USERID_PKG AS

1: PACKAGE BODY IGS_PE_USERID_PKG AS
2: /* $Header: IGSPE11B.pls 120.14 2006/09/21 13:06:35 gmaheswa ship $ */
3:
4: /* +=======================================================================+
5: | Copyright (c) 2000 Oracle Corporation, Redwood Shores, CA, USA |

Line 59: l_prog_label CONSTANT VARCHAR2(500) :='igs.plsql.igs_pe_userid_pkg';

55: introduced validate_password logic
56: | 21-Sep-2006 gmaheswa Bug 5546771 Modified generate_password logic to repeat for 500 times.
57: +=======================================================================+ */
58:
59: l_prog_label CONSTANT VARCHAR2(500) :='igs.plsql.igs_pe_userid_pkg';
60: l_label VARCHAR2(4000);
61: l_debug_str VARCHAR2(32000);
62:
63:

Line 188: l_label := 'igs.plsql.igs_pe_userid_pkg.GENERATE_USERNAME';

184: l_item_key := P_EVENT.GetValueForParameter('ITEM_KEY');
185: l_party_id := P_EVENT.GetValueForParameter('PARTY_ID');
186:
187: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
188: l_label := 'igs.plsql.igs_pe_userid_pkg.GENERATE_USERNAME';
189: l_debug_str := 'Begin for Party ID:'||l_party_id;
190: fnd_log.string( fnd_log.level_procedure,l_label,l_debug_str);
191: END IF;
192:

Line 256: l_label := 'igs.plsql.igs_pe_userid_pkg.GENERATE_USERNAME';

252: END IF;
253:
254: IF l_party_id IS NULL THEN
255: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
256: l_label := 'igs.plsql.igs_pe_userid_pkg.GENERATE_USERNAME';
257: l_debug_str := 'Self Service Reg, User Name: '||l_user_name;
258: fnd_log.string(fnd_log.level_procedure,l_label,l_debug_str);
259: END IF;
260: p_event.addParametertoList('USER_NAME', l_user_name);

Line 263: l_label := 'igs.plsql.igs_pe_userid_pkg.GENERATE_USERNAME';

259: END IF;
260: p_event.addParametertoList('USER_NAME', l_user_name);
261: ELSE
262: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
263: l_label := 'igs.plsql.igs_pe_userid_pkg.GENERATE_USERNAME';
264: l_debug_str := 'Batch user creation, User Name: '||l_user_name;
265: fnd_log.string( fnd_log.level_procedure,l_label,l_debug_str);
266: END IF;
267:

Line 278: l_label := 'igs.plsql.igs_pe_userid_pkg.GENERATE_USERNAME';

274:
275: EXCEPTION
276: WHEN OTHERS THEN
277: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
278: l_label := 'igs.plsql.igs_pe_userid_pkg.GENERATE_USERNAME';
279: l_debug_str := 'EXCEPTION: '||SQLERRM;
280: fnd_log.string(fnd_log.level_procedure,l_label,l_debug_str);
281: END IF;
282:

Line 283: WF_CORE.CONTEXT('IGS_PE_USERID_PKG','GENERATE_USERNAME',p_event.event_name,p_event.event_key, sqlerrm,sqlcode);

279: l_debug_str := 'EXCEPTION: '||SQLERRM;
280: fnd_log.string(fnd_log.level_procedure,l_label,l_debug_str);
281: END IF;
282:
283: WF_CORE.CONTEXT('IGS_PE_USERID_PKG','GENERATE_USERNAME',p_event.event_name,p_event.event_key, sqlerrm,sqlcode);
284: wf_event.setErrorInfo(p_event,'ERROR');
285: RAISE;
286: return('ERROR');
287: end;

Line 351: wf_core.context('IGS_PE_USERID_PKG', l_api_name,

347: EXCEPTION
348:
349: WHEN OTHERS THEN
350:
351: wf_core.context('IGS_PE_USERID_PKG', l_api_name,
352: itemtype, itemkey, to_char(actid), funcmode,Generate_Message());
353: RAISE ;
354:
355: END Check_Setup ;

Line 439: WF_CORE.CONTEXT('IGS_PE_USERID_PKG','GENERATE_PARTY_NUMBER',p_event.event_name,p_event.event_key, sqlerrm,sqlcode);

435: RETURN(l_result);
436:
437: EXCEPTION
438: WHEN OTHERS THEN
439: WF_CORE.CONTEXT('IGS_PE_USERID_PKG','GENERATE_PARTY_NUMBER',p_event.event_name,p_event.event_key, sqlerrm,sqlcode);
440: wf_event.setErrorInfo(p_event,'ERROR');
441: RAISE;
442: RETURN('ERROR');
443: END generate_party_number;

Line 555: wf_core.context('IGS_PE_USERID_PKG', l_api_name,

551: EXCEPTION
552:
553: WHEN OTHERS THEN
554:
555: wf_core.context('IGS_PE_USERID_PKG', l_api_name,
556: itemtype, itemkey, to_char(actid), funcmode,Generate_Message(),l_user_name,sqlerrm,fnd_message.get);
557: RAISE ;
558:
559: END Create_Fnd_User ;

Line 784: FND_MSG_PUB.Add_Exc_Msg ('IGS_PE_USERID_PKG', l_api_name);

780: Rollback to Generate_User;
781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
782:
783: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
784: FND_MSG_PUB.Add_Exc_Msg ('IGS_PE_USERID_PKG', l_api_name);
785: END IF;
786:
787: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
788: p_data => x_msg_data );

Line 988: FND_MSG_PUB.Add_Exc_Msg ('IGS_PE_USERID_PKG',

984: IF (c_person_id_group%ISOPEN) THEN
985: CLOSE c_person_id_group;
986: END IF;
987: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
988: FND_MSG_PUB.Add_Exc_Msg ('IGS_PE_USERID_PKG',
989: l_api_name);
990: END IF;
991:
992: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,

Line 1140: 'IGS_PE_USERID_PKG' )) THEN

1136: --
1137: IF (NOT FND_API.Compatible_API_Call ( l_api_version,
1138: p_api_version,
1139: l_api_name,
1140: 'IGS_PE_USERID_PKG' )) THEN
1141: raise FND_API.G_EXC_UNEXPECTED_ERROR ;
1142: END IF;
1143:
1144: --

Line 1296: FND_MSG_PUB.Add_Exc_Msg ('IGS_PE_USERID_PKG', l_api_name);

1292: WHEN OTHERS THEN
1293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1294: ROLLBACK TO Process_Group_ID_PVT;
1295: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
1296: FND_MSG_PUB.Add_Exc_Msg ('IGS_PE_USERID_PKG', l_api_name);
1297: END IF;
1298: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
1299: p_data => l_msg_data );
1300:

Line 1456: l_label := 'igs.plsql.igs_pe_userid_pkg.umx_business_logic';

1452: BEGIN
1453: l_event_context := p_event.getvalueforparameter ('UMX_CUSTOM_EVENT_CONTEXT');
1454:
1455: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1456: l_label := 'igs.plsql.igs_pe_userid_pkg.umx_business_logic';
1457: l_debug_str := 'Begin for UMX_CUSTOM_EVENT_CONTEXT:'||l_event_context;
1458: fnd_log.string( fnd_log.level_procedure,l_label,l_debug_str);
1459: END IF;
1460:

Line 1479: l_label := 'igs.plsql.igs_pe_userid_pkg.umx_business_logic: UMX_PUB.BEFORE_ACT_ACTIVATION';

1475: l_email_address := p_event.getvalueforparameter ('EMAIL_ADDRESS' );
1476: l_person_id := p_event.getvalueforparameter ('PERSON_PARTY_ID');
1477:
1478: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1479: l_label := 'igs.plsql.igs_pe_userid_pkg.umx_business_logic: UMX_PUB.BEFORE_ACT_ACTIVATION';
1480: l_debug_str := 'Event Parameters: IGS_TITLE: '||l_title||' IGS_PREFIX: '||l_prefix||' IGS_PREF_ALT_ID: '||l_alt_id
1481: ||' IGS_PERSON_NUMBER: '||l_person_number||' FIRST_NAME: '||l_given_name||' IGS_PREF_NAME: '||l_pref_name
1482: ||' MIDDLE_NAME: '||l_middle_name||' IGS_GENDER: '||l_gender||' LAST_NAME: '||l_surname
1483: ||' IGS_BIRTH_DATE: '||l_birth||' PERSON_SUFFIX: '||l_suffix||' REQUESTED_USERNAME: '||l_user_name

Line 1501: l_label := 'igs.plsql.igs_pe_userid_pkg.umx_business_logic: person_id IS NULL';

1497: FETCH c_id_type INTO l_id_type;
1498: CLOSE c_id_type;
1499:
1500: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1501: l_label := 'igs.plsql.igs_pe_userid_pkg.umx_business_logic: person_id IS NULL';
1502: l_debug_str := 'Before Person Insert';
1503: fnd_log.string( fnd_log.level_procedure,l_label,l_debug_str);
1504: END IF;
1505:

Line 1569: l_label := 'igs.plsql.igs_pe_userid_pkg.umx_business_logic: person_id IS NULL';

1565: x_attribute24 => ''
1566: );
1567:
1568: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1569: l_label := 'igs.plsql.igs_pe_userid_pkg.umx_business_logic: person_id IS NULL';
1570: l_debug_str := 'After Person Insert Call: l_return_status: '||l_return_status||'***l_person_id: '||l_person_id||'****l_msg_data/sqlerrm/l_msg_count:'||l_msg_data||'/'||l_msg_count;
1571: fnd_log.string( fnd_log.level_procedure,l_label,l_debug_str);
1572: END IF;
1573: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

Line 1580: l_label := 'igs.plsql.igs_pe_userid_pkg.umx_business_logic: person_id IS NOT NULL';

1576: P_ATTR_VALUE => l_person_id);
1577: END IF;
1578: ELSE
1579: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1580: l_label := 'igs.plsql.igs_pe_userid_pkg.umx_business_logic: person_id IS NOT NULL';
1581: l_debug_str := 'l_person_id: '||l_person_id;
1582: fnd_log.string( fnd_log.level_procedure,l_label,l_debug_str);
1583: END IF;
1584: UMX_PUB.updateWfAttribute (p_event => p_event,

Line 1596: l_label := 'igs.plsql.igs_pe_userid_pkg.umx_business_logic: After Successful Insert of Person';

1592: OPEN c_email(l_person_id);
1593: FETCH c_email INTO l_new_address;
1594: CLOSE c_email;
1595: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1596: l_label := 'igs.plsql.igs_pe_userid_pkg.umx_business_logic: After Successful Insert of Person';
1597: l_debug_str := 'Before insert/update of Email Address: l_new_address: '||l_new_address||'***l_email_address: '||l_email_address;
1598: fnd_log.string( fnd_log.level_procedure,l_label,l_debug_str);
1599: END IF;
1600:

Line 1618: l_label := 'igs.plsql.igs_pe_userid_pkg.umx_business_logic';

1614: p_contact_point_id => l_contact_point_id,
1615: p_contact_point_ovn => l_contact_point_ovn
1616: ) ;
1617: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1618: l_label := 'igs.plsql.igs_pe_userid_pkg.umx_business_logic';
1619: l_debug_str := 'After IGS_PE_CONTACT_POINT_PKG.HZ_CONTACT_POINTS_AKE: l_return_status: '||l_return_status||'***l_msg_data/sqlerrm:'||l_msg_data;
1620: fnd_log.string( fnd_log.level_procedure,l_label,l_debug_str);
1621: END IF;
1622: END IF;

Line 1626: l_label := 'igs.plsql.igs_pe_userid_pkg.umx_business_logic';

1622: END IF;
1623:
1624: END IF;
1625: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1626: l_label := 'igs.plsql.igs_pe_userid_pkg.umx_business_logic';
1627: l_debug_str := 'END OF UMX_PUB.BEFORE_ACT_ACTIVATION';
1628: fnd_log.string( fnd_log.level_procedure,l_label,l_debug_str);
1629: END IF;
1630:

Line 1634: l_label := 'igs.plsql.igs_pe_userid_pkg.umx_business_logic';

1630:
1631: ELSIF l_event_context = UMX_PUB.AFTER_ACT_ACTIVATION THEN
1632:
1633: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1634: l_label := 'igs.plsql.igs_pe_userid_pkg.umx_business_logic';
1635: l_debug_str := 'Start Of UMX_PUB.AFTER_ACT_ACTIVATION';
1636: fnd_log.string( fnd_log.level_procedure,l_label,l_debug_str);
1637: END IF;
1638:

Line 1644: l_label := 'igs.plsql.igs_pe_userid_pkg.umx_business_logic';

1640: l_user_id := p_event.getvalueforparameter ('REQUESTED_FOR_USER_ID');
1641:
1642: assign_responsibility(l_person_id, l_user_id);
1643: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1644: l_label := 'igs.plsql.igs_pe_userid_pkg.umx_business_logic';
1645: l_debug_str := 'End Of UMX_PUB.AFTER_ACT_ACTIVATION: l_person_id: '||l_person_id||'***l_user_id: '||l_user_id;
1646: fnd_log.string( fnd_log.level_procedure,l_label,l_debug_str);
1647: END IF;
1648: END IF;

Line 1653: l_label := 'igs.plsql.igs_pe_userid_pkg.umx_business_logic';

1649:
1650: l_result := wf_rule.default_rule(p_subscription_guid, p_event);
1651:
1652: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1653: l_label := 'igs.plsql.igs_pe_userid_pkg.umx_business_logic';
1654: l_debug_str := 'End Of umx_business_logic: l_result: '||l_result;
1655: fnd_log.string( fnd_log.level_procedure,l_label,l_debug_str);
1656: END IF;
1657:

Line 1664: l_label := 'igs.plsql.igs_pe_userid_pkg.umx_business_logic';

1660: EXCEPTION
1661: WHEN OTHERS THEN
1662:
1663: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1664: l_label := 'igs.plsql.igs_pe_userid_pkg.umx_business_logic';
1665: l_debug_str := 'Exception: SQLERRM :'||SQLERRM||'***TRACE : '||DBMS_UTILITY.FORMAT_ERROR_BACKTRACE;
1666: fnd_log.string( fnd_log.level_procedure,l_label,l_debug_str);
1667: END IF;
1668: WF_CORE.CONTEXT('IGS_PE_USERID_PKG','UMX_BUSINESS_LOGIC',p_event.geteventname, p_subscription_guid, sqlerrm, sqlcode);

Line 1668: WF_CORE.CONTEXT('IGS_PE_USERID_PKG','UMX_BUSINESS_LOGIC',p_event.geteventname, p_subscription_guid, sqlerrm, sqlcode);

1664: l_label := 'igs.plsql.igs_pe_userid_pkg.umx_business_logic';
1665: l_debug_str := 'Exception: SQLERRM :'||SQLERRM||'***TRACE : '||DBMS_UTILITY.FORMAT_ERROR_BACKTRACE;
1666: fnd_log.string( fnd_log.level_procedure,l_label,l_debug_str);
1667: END IF;
1668: WF_CORE.CONTEXT('IGS_PE_USERID_PKG','UMX_BUSINESS_LOGIC',p_event.geteventname, p_subscription_guid, sqlerrm, sqlcode);
1669: wf_event.setErrorInfo(p_event,'ERROR');
1670: RAISE;
1671: RETURN('ERROR');
1672: END umx_business_logic;

Line 1802: l_label := 'igs.plsql.igs_pe_userid_pkg.Validate_Person.Dup_Person_Check';

1798: CLOSE cur_hz_parties;
1799:
1800: IF l_count > 1 THEN
1801: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1802: l_label := 'igs.plsql.igs_pe_userid_pkg.Validate_Person.Dup_Person_Check';
1803: l_debug_str := 'Multiple Matche records found with out considering ZipCode.';
1804: fnd_log.string( fnd_log.level_procedure,l_label,l_debug_str);
1805: END IF;
1806: -- Too many users

Line 1827: l_label := 'igs.plsql.igs_pe_userid_pkg.Validate_Person.Dup_Person_Check';

1823: END IF;
1824:
1825: IF (l_count = 1 OR l_zip_exact_match = TRUE) THEN
1826: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1827: l_label := 'igs.plsql.igs_pe_userid_pkg.Validate_Person.Dup_Person_Check';
1828: l_debug_str := 'Exact match found: Person_Id = '||l_party_id;
1829: fnd_log.string( fnd_log.level_procedure,l_label,l_debug_str);
1830: END IF;
1831: OPEN c_fnd_user(l_party_id);

Line 1850: l_label := 'igs.plsql.igs_pe_userid_pkg.Validate_Person.Dup_Person_Check';

1846: END IF;
1847:
1848: IF (l_count = 0 OR l_zip_no_match) THEN
1849: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1850: l_label := 'igs.plsql.igs_pe_userid_pkg.Validate_Person.Dup_Person_Check';
1851: l_debug_str := 'Exact match not found for '||p_isApplicant;
1852: fnd_log.string( fnd_log.level_procedure,l_label,l_debug_str);
1853: END IF;
1854:

Line 2040: l_label := 'igs.plsql.igs_pe_userid_pkg.Validate_Person';

2036: FND_MSG_PUB.Add;
2037: RAISE FND_API.G_EXC_ERROR;
2038: END IF;
2039: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
2040: l_label := 'igs.plsql.igs_pe_userid_pkg.Validate_Person';
2041: l_debug_str := 'Auto Generated Person Number is '||p_person_num;
2042: fnd_log.string( fnd_log.level_procedure,l_label,l_debug_str);
2043: END IF;
2044: END IF;

Line 2083: l_label := 'igs.plsql.igs_pe_userid_pkg.auto_generate_username';

2079: l_parameter_list_t wf_parameter_list_t;
2080:
2081: BEGIN
2082: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
2083: l_label := 'igs.plsql.igs_pe_userid_pkg.auto_generate_username';
2084: l_debug_str := 'p_person_number: '||p_person_number||' p_first_name: '||p_first_name||' p_last_name: '||p_last_name
2085: ||' p_middle_name: '||p_middle_name||' p_pref_name: '||p_pref_name||'p_pref_alt_id: '||p_pref_alt_id
2086: ||' p_title: '||p_title||' p_prefix: '||p_prefix||' p_suffix: '||p_suffix||'p_gender'||p_gender
2087: ||' p_birth_date: '||p_birth_date||' p_email_address: '||p_email_address||' p_email_format: '||p_email_format;

Line 2150: l_label := 'igs.plsql.igs_pe_userid_pkg.auto_generate_username: End';

2146:
2147: p_user_name := UPPER(WF_EVENT.getValueForParameter ('USER_NAME',l_parameter_list_t));
2148:
2149: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
2150: l_label := 'igs.plsql.igs_pe_userid_pkg.auto_generate_username: End';
2151: l_debug_str := 'p_user_name: '||p_user_name;
2152: fnd_log.string( fnd_log.level_procedure,l_label,l_debug_str);
2153: END IF;
2154: END AUTO_GENERATE_USERNAME;

Line 2260: END IGS_PE_USERID_PKG;

2256: x_return_status := 'E';
2257: END IF;
2258: END validate_password;
2259:
2260: END IGS_PE_USERID_PKG;