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 FND_LOG

Line 187: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

183:
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;

Line 190: fnd_log.string( fnd_log.level_procedure,l_label,l_debug_str);

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:
193: /*
194: If l_party_id IS null that means the event is raised for Self-Service Registration

Line 255: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

251: RAISE FND_API.G_EXC_ERROR;
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;

Line 258: fnd_log.string(fnd_log.level_procedure,l_label,l_debug_str);

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);
261: ELSE
262: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

Line 262: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

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);
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;

Line 265: fnd_log.string( fnd_log.level_procedure,l_label,l_debug_str);

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:
268: wf_engine.SetItemAttrText(l_wf_name,l_item_key,'USER_NAME',l_user_name);
269: END IF;

Line 277: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

273: return(l_result);
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;

Line 280: fnd_log.string(fnd_log.level_procedure,l_label,l_debug_str);

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:
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');

Line 1455: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

1451:
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;

Line 1458: fnd_log.string( fnd_log.level_procedure,l_label,l_debug_str);

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:
1461: IF l_event_context = UMX_PUB.BEFORE_ACT_ACTIVATION THEN
1462: l_title := p_event.getvalueforparameter ('IGS_TITLE');

Line 1478: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

1474: l_email_format := p_event.getvalueforparameter ('EMAIL_FORMAT');
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

Line 1485: fnd_log.string( fnd_log.level_procedure,l_label,l_debug_str);

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
1484: ||' EMAIL_FORMAT: '||l_email_format||' EMAIL_ADDRESS: '||l_email_address||' PERSON_PARTY_ID: '||l_person_id;
1485: fnd_log.string( fnd_log.level_procedure,l_label,l_debug_str);
1486: END IF;
1487:
1488: IF l_birth IS NOT NULL THEN
1489: OPEN c_dt_format(l_birth);

Line 1500: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

1496: OPEN c_id_type;
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;

Line 1503: fnd_log.string( fnd_log.level_procedure,l_label,l_debug_str);

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:
1506: igs_pe_person_pkg.insert_row(
1507: x_msg_count => l_msg_count,

Line 1568: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

1564: x_attribute23 => '',
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;

Line 1571: fnd_log.string( fnd_log.level_procedure,l_label,l_debug_str);

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
1574: UMX_PUB.updateWfAttribute (p_event => p_event,
1575: P_ATTR_NAME => 'PERSON_PARTY_ID',

Line 1579: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

1575: P_ATTR_NAME => 'PERSON_PARTY_ID',
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;

Line 1582: fnd_log.string( fnd_log.level_procedure,l_label,l_debug_str);

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,
1585: P_ATTR_NAME => 'PERSON_PARTY_ID',
1586: P_ATTR_VALUE => l_person_id);

Line 1595: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

1591: IF l_return_status IS NULL or l_return_status = FND_API.G_RET_STS_SUCCESS THEN
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;

Line 1598: fnd_log.string( fnd_log.level_procedure,l_label,l_debug_str);

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:
1601: IF l_new_address IS NULL OR l_email_address <> l_new_address THEN
1602: IGS_PE_CONTACT_POINT_PKG.HZ_CONTACT_POINTS_AKE(

Line 1617: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

1613: p_last_update_date => l_date,
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;

Line 1620: fnd_log.string( fnd_log.level_procedure,l_label,l_debug_str);

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;
1623:
1624: END IF;

Line 1625: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

1621: END IF;
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;

Line 1628: fnd_log.string( fnd_log.level_procedure,l_label,l_debug_str);

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:
1631: ELSIF l_event_context = UMX_PUB.AFTER_ACT_ACTIVATION THEN
1632:

Line 1633: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

1629: END IF;
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;

Line 1636: fnd_log.string( fnd_log.level_procedure,l_label,l_debug_str);

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:
1639: l_person_id := p_event.getvalueforparameter ('PERSON_PARTY_ID');
1640: l_user_id := p_event.getvalueforparameter ('REQUESTED_FOR_USER_ID');

Line 1643: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

1639: l_person_id := p_event.getvalueforparameter ('PERSON_PARTY_ID');
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;

Line 1646: fnd_log.string( fnd_log.level_procedure,l_label,l_debug_str);

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;
1649:
1650: l_result := wf_rule.default_rule(p_subscription_guid, p_event);

Line 1652: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

1648: END IF;
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;

Line 1655: fnd_log.string( fnd_log.level_procedure,l_label,l_debug_str);

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:
1658: RETURN(l_result);
1659:

Line 1663: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

1659:
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;

Line 1666: fnd_log.string( fnd_log.level_procedure,l_label,l_debug_str);

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);
1669: wf_event.setErrorInfo(p_event,'ERROR');
1670: RAISE;

Line 1801: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

1797: FETCH cur_hz_parties INTO l_count, l_party_id;
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;

Line 1804: fnd_log.string( fnd_log.level_procedure,l_label,l_debug_str);

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
1807: IF p_Zipcode IS NULL THEN
1808: x_return_status := 'E';

Line 1826: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

1822: END IF;
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;

Line 1829: fnd_log.string( fnd_log.level_procedure,l_label,l_debug_str);

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);
1832: FETCH c_fnd_user INTO l_user_id;
1833: CLOSE c_fnd_user;

Line 1849: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

1845: END IF;
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;

Line 1852: fnd_log.string( fnd_log.level_procedure,l_label,l_debug_str);

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:
1855: IF p_isApplicant = 'APPLICANT_YES' THEN
1856: RETURN;

Line 2039: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

2035: FND_MESSAGE.SET_NAME('IGS', 'IGS_PE_ACCREQ_SETUP_N_COMPL');
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;

Line 2042: fnd_log.string( fnd_log.level_procedure,l_label,l_debug_str);

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;
2045:
2046: x_return_status := 'S';

Line 2082: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

2078: l_event_t wf_event_t;
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

Line 2088: fnd_log.string( fnd_log.level_procedure,l_label,l_debug_str);

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;
2088: fnd_log.string( fnd_log.level_procedure,l_label,l_debug_str);
2089: END IF;
2090:
2091: -- initialize the parameter list.
2092: wf_event_t.Initialize(l_event_t);

Line 2149: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

2145: );
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;

Line 2152: fnd_log.string( fnd_log.level_procedure,l_label,l_debug_str);

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;
2155:
2156: PROCEDURE process_alumni_nomatch_event