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 WF_EVENT

Line 146: P_EVENT in out NOCOPY wf_event_t

142: */
143:
144: FUNCTION GENERATE_USERNAME (
145: P_SUBSCRIPTION_GUID in raw,
146: P_EVENT in out NOCOPY wf_event_t
147: ) return varchar2 is
148: ------------------------------------------------------------------------------
149: l_result varchar2(100);
150:

Line 284: wf_event.setErrorInfo(p_event,'ERROR');

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

Line 362: l_event_t wf_event_t;

358: IS
359:
360: l_return_status VARCHAR2(1);
361: l_count NUMBER(9);
362: l_event_t wf_event_t;
363: l_parameter_list_t wf_parameter_list_t;
364: l_wf_name VARCHAR2(8) ;
365: itemkey VARCHAR2(100);
366:

Line 371: wf_event_t.Initialize(l_event_t);

367: BEGIN
368: itemkey :=substr(FND_CRYPTO.RANDOMNUMBER,1,5);
369: l_wf_name :='IGSPEGEN';
370: -- initialize the parameter list.
371: wf_event_t.Initialize(l_event_t);
372:
373: -- set the parameters. This parameter is added with null value to initialize the parameter list.
374: wf_event.AddParameterToList ( p_name => 'PARAMETER_DUMMY',
375: p_value => NULL,

Line 374: wf_event.AddParameterToList ( p_name => 'PARAMETER_DUMMY',

370: -- initialize the parameter list.
371: wf_event_t.Initialize(l_event_t);
372:
373: -- set the parameters. This parameter is added with null value to initialize the parameter list.
374: wf_event.AddParameterToList ( p_name => 'PARAMETER_DUMMY',
375: p_value => NULL,
376: p_parameterlist => l_parameter_list_t);
377:
378: WF_EVENT.RAISE3(p_event_name => 'oracle.apps.igs.pe.party_number.generate',

Line 378: WF_EVENT.RAISE3(p_event_name => 'oracle.apps.igs.pe.party_number.generate',

374: wf_event.AddParameterToList ( p_name => 'PARAMETER_DUMMY',
375: p_value => NULL,
376: p_parameterlist => l_parameter_list_t);
377:
378: WF_EVENT.RAISE3(p_event_name => 'oracle.apps.igs.pe.party_number.generate',
379: p_event_key => 'GEN_PARTY_NUM'||itemkey,
380: p_event_data => NULL,
381: p_parameter_list => l_parameter_list_t,
382: p_send_date => sysdate

Line 384: p_person_number := UPPER(WF_EVENT.getValueForParameter('PERSON_NUMBER',l_parameter_list_t));

380: p_event_data => NULL,
381: p_parameter_list => l_parameter_list_t,
382: p_send_date => sysdate
383: );
384: p_person_number := UPPER(WF_EVENT.getValueForParameter('PERSON_NUMBER',l_parameter_list_t));
385: l_parameter_list_t.delete;
386:
387: END get_person_number ;
388:

Line 391: P_EVENT in out NOCOPY wf_event_t

387: END get_person_number ;
388:
389: FUNCTION generate_party_number (
390: P_SUBSCRIPTION_GUID in raw,
391: P_EVENT in out NOCOPY wf_event_t
392: ) return varchar2 is
393: /*
394: || Created By : GMAHESWA
395: || Created On : 4-May-2006

Line 440: wf_event.setErrorInfo(p_event,'ERROR');

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

Line 1396: p_event IN OUT NOCOPY WF_EVENT_T

1392: END assign_responsibility;
1393:
1394: FUNCTION umx_business_logic(
1395: p_subscription_guid IN RAW,
1396: p_event IN OUT NOCOPY WF_EVENT_T
1397: ) RETURN VARCHAR2
1398: IS
1399:
1400: l_result VARCHAR2(100);

Line 1669: wf_event.setErrorInfo(p_event,'ERROR');

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

Line 1782: l_wf_event_t WF_EVENT_T;

1778: AND SYSDATE BETWEEN hzp.effective_start_date
1779: AND NVL(hzp.effective_end_date,sysdate)
1780: AND hz.POSTAL_CODE= cp_zipcode;
1781:
1782: l_wf_event_t WF_EVENT_T;
1783: l_wf_parameter_list_t WF_PARAMETER_LIST_T;
1784:
1785: CURSOR c_seq_num IS
1786: SELECT IGS_PE_GEN_USER_S.nextval

Line 1859: WF_EVENT_T.Initialize(l_wf_event_t);

1855: IF p_isApplicant = 'APPLICANT_YES' THEN
1856: RETURN;
1857: ELSE
1858: -- Raise business event 'oracle.apps.igs.pe.accountrequest.alumni_nomatch' setting all parameters.
1859: WF_EVENT_T.Initialize(l_wf_event_t);
1860: l_wf_event_t.setEventName( pEventName => 'oracle.apps.igs.pe.accountrequest.alumni_nomatch');
1861: wf_event.AddParameterToList ( p_name => 'PERSON_NUMBER',
1862: p_value => p_person_num,
1863: p_parameterlist => l_wf_parameter_list_t);

Line 1860: l_wf_event_t.setEventName( pEventName => 'oracle.apps.igs.pe.accountrequest.alumni_nomatch');

1856: RETURN;
1857: ELSE
1858: -- Raise business event 'oracle.apps.igs.pe.accountrequest.alumni_nomatch' setting all parameters.
1859: WF_EVENT_T.Initialize(l_wf_event_t);
1860: l_wf_event_t.setEventName( pEventName => 'oracle.apps.igs.pe.accountrequest.alumni_nomatch');
1861: wf_event.AddParameterToList ( p_name => 'PERSON_NUMBER',
1862: p_value => p_person_num,
1863: p_parameterlist => l_wf_parameter_list_t);
1864: wf_event.AddParameterToList ( p_name => 'ALT_ID',

Line 1861: wf_event.AddParameterToList ( p_name => 'PERSON_NUMBER',

1857: ELSE
1858: -- Raise business event 'oracle.apps.igs.pe.accountrequest.alumni_nomatch' setting all parameters.
1859: WF_EVENT_T.Initialize(l_wf_event_t);
1860: l_wf_event_t.setEventName( pEventName => 'oracle.apps.igs.pe.accountrequest.alumni_nomatch');
1861: wf_event.AddParameterToList ( p_name => 'PERSON_NUMBER',
1862: p_value => p_person_num,
1863: p_parameterlist => l_wf_parameter_list_t);
1864: wf_event.AddParameterToList ( p_name => 'ALT_ID',
1865: p_value => p_pref_alt_id,

Line 1864: wf_event.AddParameterToList ( p_name => 'ALT_ID',

1860: l_wf_event_t.setEventName( pEventName => 'oracle.apps.igs.pe.accountrequest.alumni_nomatch');
1861: wf_event.AddParameterToList ( p_name => 'PERSON_NUMBER',
1862: p_value => p_person_num,
1863: p_parameterlist => l_wf_parameter_list_t);
1864: wf_event.AddParameterToList ( p_name => 'ALT_ID',
1865: p_value => p_pref_alt_id,
1866: p_parameterlist => l_wf_parameter_list_t);
1867: wf_event.AddParameterToList ( p_name => 'GENDER',
1868: p_value => p_gender,

Line 1867: wf_event.AddParameterToList ( p_name => 'GENDER',

1863: p_parameterlist => l_wf_parameter_list_t);
1864: wf_event.AddParameterToList ( p_name => 'ALT_ID',
1865: p_value => p_pref_alt_id,
1866: p_parameterlist => l_wf_parameter_list_t);
1867: wf_event.AddParameterToList ( p_name => 'GENDER',
1868: p_value => p_gender,
1869: p_parameterlist => l_wf_parameter_list_t);
1870: wf_event.AddParameterToList ( p_name => 'BIRTH_DATE',
1871: p_value => p_birth_date,

Line 1870: wf_event.AddParameterToList ( p_name => 'BIRTH_DATE',

1866: p_parameterlist => l_wf_parameter_list_t);
1867: wf_event.AddParameterToList ( p_name => 'GENDER',
1868: p_value => p_gender,
1869: p_parameterlist => l_wf_parameter_list_t);
1870: wf_event.AddParameterToList ( p_name => 'BIRTH_DATE',
1871: p_value => p_birth_date,
1872: p_parameterlist => l_wf_parameter_list_t);
1873: wf_event.AddParameterToList ( p_name => 'SURNAME',
1874: p_value => p_last_name,

Line 1873: wf_event.AddParameterToList ( p_name => 'SURNAME',

1869: p_parameterlist => l_wf_parameter_list_t);
1870: wf_event.AddParameterToList ( p_name => 'BIRTH_DATE',
1871: p_value => p_birth_date,
1872: p_parameterlist => l_wf_parameter_list_t);
1873: wf_event.AddParameterToList ( p_name => 'SURNAME',
1874: p_value => p_last_name,
1875: p_parameterlist => l_wf_parameter_list_t);
1876: wf_event.AddParameterToList ( p_name => 'GIVEN_NAME',
1877: p_value => p_first_name,

Line 1876: wf_event.AddParameterToList ( p_name => 'GIVEN_NAME',

1872: p_parameterlist => l_wf_parameter_list_t);
1873: wf_event.AddParameterToList ( p_name => 'SURNAME',
1874: p_value => p_last_name,
1875: p_parameterlist => l_wf_parameter_list_t);
1876: wf_event.AddParameterToList ( p_name => 'GIVEN_NAME',
1877: p_value => p_first_name,
1878: p_parameterlist => l_wf_parameter_list_t);
1879: wf_event.AddParameterToList ( p_name => 'USER_EMAIL',
1880: p_value => p_email_address,

Line 1879: wf_event.AddParameterToList ( p_name => 'USER_EMAIL',

1875: p_parameterlist => l_wf_parameter_list_t);
1876: wf_event.AddParameterToList ( p_name => 'GIVEN_NAME',
1877: p_value => p_first_name,
1878: p_parameterlist => l_wf_parameter_list_t);
1879: wf_event.AddParameterToList ( p_name => 'USER_EMAIL',
1880: p_value => p_email_address,
1881: p_parameterlist => l_wf_parameter_list_t);
1882: wf_event.AddParameterToList ( p_name => 'ZIP_CODE',
1883: p_value => p_Zipcode,

Line 1882: wf_event.AddParameterToList ( p_name => 'ZIP_CODE',

1878: p_parameterlist => l_wf_parameter_list_t);
1879: wf_event.AddParameterToList ( p_name => 'USER_EMAIL',
1880: p_value => p_email_address,
1881: p_parameterlist => l_wf_parameter_list_t);
1882: wf_event.AddParameterToList ( p_name => 'ZIP_CODE',
1883: p_value => p_Zipcode,
1884: p_parameterlist => l_wf_parameter_list_t);
1885: wf_event.AddParameterToList ( p_name => 'PHONE_COUNTRY_CODE',
1886: p_value => p_phoneCountry,

Line 1885: wf_event.AddParameterToList ( p_name => 'PHONE_COUNTRY_CODE',

1881: p_parameterlist => l_wf_parameter_list_t);
1882: wf_event.AddParameterToList ( p_name => 'ZIP_CODE',
1883: p_value => p_Zipcode,
1884: p_parameterlist => l_wf_parameter_list_t);
1885: wf_event.AddParameterToList ( p_name => 'PHONE_COUNTRY_CODE',
1886: p_value => p_phoneCountry,
1887: p_parameterlist => l_wf_parameter_list_t);
1888: wf_event.AddParameterToList ( p_name => 'PHONE_AREA_CODE',
1889: p_value => p_phoneArea,

Line 1888: wf_event.AddParameterToList ( p_name => 'PHONE_AREA_CODE',

1884: p_parameterlist => l_wf_parameter_list_t);
1885: wf_event.AddParameterToList ( p_name => 'PHONE_COUNTRY_CODE',
1886: p_value => p_phoneCountry,
1887: p_parameterlist => l_wf_parameter_list_t);
1888: wf_event.AddParameterToList ( p_name => 'PHONE_AREA_CODE',
1889: p_value => p_phoneArea,
1890: p_parameterlist => l_wf_parameter_list_t);
1891: wf_event.AddParameterToList ( p_name => 'PHONE_NUMBER',
1892: p_value => p_phoneNumber,

Line 1891: wf_event.AddParameterToList ( p_name => 'PHONE_NUMBER',

1887: p_parameterlist => l_wf_parameter_list_t);
1888: wf_event.AddParameterToList ( p_name => 'PHONE_AREA_CODE',
1889: p_value => p_phoneArea,
1890: p_parameterlist => l_wf_parameter_list_t);
1891: wf_event.AddParameterToList ( p_name => 'PHONE_NUMBER',
1892: p_value => p_phoneNumber,
1893: p_parameterlist => l_wf_parameter_list_t);
1894: wf_event.AddParameterToList ( p_name => 'ADMIN_USERNAME',
1895: p_value => FND_PROFILE.VALUE('IGS_PE_USER_ADMIN'),

Line 1894: wf_event.AddParameterToList ( p_name => 'ADMIN_USERNAME',

1890: p_parameterlist => l_wf_parameter_list_t);
1891: wf_event.AddParameterToList ( p_name => 'PHONE_NUMBER',
1892: p_value => p_phoneNumber,
1893: p_parameterlist => l_wf_parameter_list_t);
1894: wf_event.AddParameterToList ( p_name => 'ADMIN_USERNAME',
1895: p_value => FND_PROFILE.VALUE('IGS_PE_USER_ADMIN'),
1896: p_parameterlist => l_wf_parameter_list_t);
1897:
1898: -- get the sequence value to be added to EVENT KEY to make it unique.

Line 1903: wf_event.raise (

1899: OPEN c_seq_num;
1900: FETCH c_seq_num INTO ln_seq_val;
1901: CLOSE c_seq_num ;
1902:
1903: wf_event.raise (
1904: p_event_name => 'oracle.apps.igs.pe.accountrequest.alumni_nomatch',
1905: p_event_key => ln_seq_val,
1906: p_parameters => l_wf_parameter_list_t,
1907: p_event_data => NULL

Line 1965: l_event_t wf_event_t;

1961: l_format igs_pe_person_id_typ.format_mask%type;
1962: l_exists VARCHAR2(1);
1963: l_alt_id_desc igs_pe_person_id_typ.description%TYPE;
1964:
1965: l_event_t wf_event_t;
1966: l_parameter_list_t wf_parameter_list_t;
1967: l_wf_name VARCHAR2(8) ;
1968: ln_seq_val NUMBER;
1969:

Line 2014: wf_event_t.Initialize(l_event_t);

2010: END IF;
2011:
2012: IF (p_isApplicant = 'APPLICANT_YES') AND (FND_PROFILE.VALUE('HZ_GENERATE_PARTY_NUMBER') = 'N') THEN
2013: -- initialize the parameter list.
2014: wf_event_t.Initialize(l_event_t);
2015:
2016: OPEN c_seq_num;
2017: FETCH c_seq_num INTO ln_seq_val;
2018: CLOSE c_seq_num ;

Line 2020: wf_event.AddParameterToList ( p_name => 'PARAMETER_DUMMY',

2016: OPEN c_seq_num;
2017: FETCH c_seq_num INTO ln_seq_val;
2018: CLOSE c_seq_num ;
2019: -- set the parameters. This parameter is added with null value to initialize the parameter list.
2020: wf_event.AddParameterToList ( p_name => 'PARAMETER_DUMMY',
2021: p_value => NULL,
2022: p_parameterlist => l_parameter_list_t);
2023:
2024: WF_EVENT.RAISE3(p_event_name => 'oracle.apps.igs.pe.party_number.generate',

Line 2024: WF_EVENT.RAISE3(p_event_name => 'oracle.apps.igs.pe.party_number.generate',

2020: wf_event.AddParameterToList ( p_name => 'PARAMETER_DUMMY',
2021: p_value => NULL,
2022: p_parameterlist => l_parameter_list_t);
2023:
2024: WF_EVENT.RAISE3(p_event_name => 'oracle.apps.igs.pe.party_number.generate',
2025: p_event_key => ln_seq_val,
2026: p_event_data => NULL,
2027: p_parameter_list => l_parameter_list_t,
2028: p_send_date => sysdate

Line 2031: p_person_num := UPPER(WF_EVENT.getValueForParameter('PERSON_NUMBER',l_parameter_list_t));

2027: p_parameter_list => l_parameter_list_t,
2028: p_send_date => sysdate
2029: );
2030:
2031: p_person_num := UPPER(WF_EVENT.getValueForParameter('PERSON_NUMBER',l_parameter_list_t));
2032: l_parameter_list_t.delete;
2033: IF (p_person_num IS NULL) THEN
2034: x_return_status := 'E';
2035: FND_MESSAGE.SET_NAME('IGS', 'IGS_PE_ACCREQ_SETUP_N_COMPL');

Line 2078: l_event_t wf_event_t;

2074: SELECT IGS_PE_GEN_USER_S.nextval
2075: FROM DUAL;
2076:
2077: ln_seq_val NUMBER;
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

Line 2092: wf_event_t.Initialize(l_event_t);

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);
2093:
2094: -- set the parameters.
2095: wf_event.AddParameterToList ( p_name => 'PERSON_NUMBER',
2096: p_value => p_person_number,

Line 2095: wf_event.AddParameterToList ( p_name => 'PERSON_NUMBER',

2091: -- initialize the parameter list.
2092: wf_event_t.Initialize(l_event_t);
2093:
2094: -- set the parameters.
2095: wf_event.AddParameterToList ( p_name => 'PERSON_NUMBER',
2096: p_value => p_person_number,
2097: p_parameterlist => l_parameter_list_t);
2098: wf_event.AddParameterToList ( p_name => 'GIVEN_NAME',
2099: p_value => p_first_name,

Line 2098: wf_event.AddParameterToList ( p_name => 'GIVEN_NAME',

2094: -- set the parameters.
2095: wf_event.AddParameterToList ( p_name => 'PERSON_NUMBER',
2096: p_value => p_person_number,
2097: p_parameterlist => l_parameter_list_t);
2098: wf_event.AddParameterToList ( p_name => 'GIVEN_NAME',
2099: p_value => p_first_name,
2100: p_parameterlist => l_parameter_list_t);
2101: wf_event.AddParameterToList ( p_name => 'SURNAME',
2102: p_value => p_last_name,

Line 2101: wf_event.AddParameterToList ( p_name => 'SURNAME',

2097: p_parameterlist => l_parameter_list_t);
2098: wf_event.AddParameterToList ( p_name => 'GIVEN_NAME',
2099: p_value => p_first_name,
2100: p_parameterlist => l_parameter_list_t);
2101: wf_event.AddParameterToList ( p_name => 'SURNAME',
2102: p_value => p_last_name,
2103: p_parameterlist => l_parameter_list_t);
2104: wf_event.AddParameterToList ( p_name => 'MIDDLE_NAME',
2105: p_value => p_middle_name,

Line 2104: wf_event.AddParameterToList ( p_name => 'MIDDLE_NAME',

2100: p_parameterlist => l_parameter_list_t);
2101: wf_event.AddParameterToList ( p_name => 'SURNAME',
2102: p_value => p_last_name,
2103: p_parameterlist => l_parameter_list_t);
2104: wf_event.AddParameterToList ( p_name => 'MIDDLE_NAME',
2105: p_value => p_middle_name,
2106: p_parameterlist => l_parameter_list_t);
2107: wf_event.AddParameterToList ( p_name => 'PREF_NAME',
2108: p_value => p_pref_name,

Line 2107: wf_event.AddParameterToList ( p_name => 'PREF_NAME',

2103: p_parameterlist => l_parameter_list_t);
2104: wf_event.AddParameterToList ( p_name => 'MIDDLE_NAME',
2105: p_value => p_middle_name,
2106: p_parameterlist => l_parameter_list_t);
2107: wf_event.AddParameterToList ( p_name => 'PREF_NAME',
2108: p_value => p_pref_name,
2109: p_parameterlist => l_parameter_list_t);
2110: wf_event.AddParameterToList ( p_name => 'ALT_ID',
2111: p_value => p_pref_alt_id,

Line 2110: wf_event.AddParameterToList ( p_name => 'ALT_ID',

2106: p_parameterlist => l_parameter_list_t);
2107: wf_event.AddParameterToList ( p_name => 'PREF_NAME',
2108: p_value => p_pref_name,
2109: p_parameterlist => l_parameter_list_t);
2110: wf_event.AddParameterToList ( p_name => 'ALT_ID',
2111: p_value => p_pref_alt_id,
2112: p_parameterlist => l_parameter_list_t);
2113: wf_event.AddParameterToList ( p_name => 'TITLE',
2114: p_value => p_title,

Line 2113: wf_event.AddParameterToList ( p_name => 'TITLE',

2109: p_parameterlist => l_parameter_list_t);
2110: wf_event.AddParameterToList ( p_name => 'ALT_ID',
2111: p_value => p_pref_alt_id,
2112: p_parameterlist => l_parameter_list_t);
2113: wf_event.AddParameterToList ( p_name => 'TITLE',
2114: p_value => p_title,
2115: p_parameterlist => l_parameter_list_t);
2116: wf_event.AddParameterToList ( p_name => 'PREFIX',
2117: p_value => p_prefix,

Line 2116: wf_event.AddParameterToList ( p_name => 'PREFIX',

2112: p_parameterlist => l_parameter_list_t);
2113: wf_event.AddParameterToList ( p_name => 'TITLE',
2114: p_value => p_title,
2115: p_parameterlist => l_parameter_list_t);
2116: wf_event.AddParameterToList ( p_name => 'PREFIX',
2117: p_value => p_prefix,
2118: p_parameterlist => l_parameter_list_t);
2119: wf_event.AddParameterToList ( p_name => 'SUFFIX',
2120: p_value => p_suffix,

Line 2119: wf_event.AddParameterToList ( p_name => 'SUFFIX',

2115: p_parameterlist => l_parameter_list_t);
2116: wf_event.AddParameterToList ( p_name => 'PREFIX',
2117: p_value => p_prefix,
2118: p_parameterlist => l_parameter_list_t);
2119: wf_event.AddParameterToList ( p_name => 'SUFFIX',
2120: p_value => p_suffix,
2121: p_parameterlist => l_parameter_list_t);
2122: wf_event.AddParameterToList ( p_name => 'GENDER',
2123: p_value => p_gender,

Line 2122: wf_event.AddParameterToList ( p_name => 'GENDER',

2118: p_parameterlist => l_parameter_list_t);
2119: wf_event.AddParameterToList ( p_name => 'SUFFIX',
2120: p_value => p_suffix,
2121: p_parameterlist => l_parameter_list_t);
2122: wf_event.AddParameterToList ( p_name => 'GENDER',
2123: p_value => p_gender,
2124: p_parameterlist => l_parameter_list_t);
2125: wf_event.AddParameterToList ( p_name => 'BIRTH_DATE',
2126: p_value => p_birth_date,

Line 2125: wf_event.AddParameterToList ( p_name => 'BIRTH_DATE',

2121: p_parameterlist => l_parameter_list_t);
2122: wf_event.AddParameterToList ( p_name => 'GENDER',
2123: p_value => p_gender,
2124: p_parameterlist => l_parameter_list_t);
2125: wf_event.AddParameterToList ( p_name => 'BIRTH_DATE',
2126: p_value => p_birth_date,
2127: p_parameterlist => l_parameter_list_t);
2128: wf_event.AddParameterToList ( p_name => 'USER_EMAIL',
2129: p_value => p_email_address,

Line 2128: wf_event.AddParameterToList ( p_name => 'USER_EMAIL',

2124: p_parameterlist => l_parameter_list_t);
2125: wf_event.AddParameterToList ( p_name => 'BIRTH_DATE',
2126: p_value => p_birth_date,
2127: p_parameterlist => l_parameter_list_t);
2128: wf_event.AddParameterToList ( p_name => 'USER_EMAIL',
2129: p_value => p_email_address,
2130: p_parameterlist => l_parameter_list_t);
2131: wf_event.AddParameterToList ( p_name => 'EMAIL_FORMAT',
2132: p_value => p_email_format,

Line 2131: wf_event.AddParameterToList ( p_name => 'EMAIL_FORMAT',

2127: p_parameterlist => l_parameter_list_t);
2128: wf_event.AddParameterToList ( p_name => 'USER_EMAIL',
2129: p_value => p_email_address,
2130: p_parameterlist => l_parameter_list_t);
2131: wf_event.AddParameterToList ( p_name => 'EMAIL_FORMAT',
2132: p_value => p_email_format,
2133: p_parameterlist => l_parameter_list_t);
2134:
2135: -- get the sequence value to be added to EVENT KEY to make it unique.

Line 2140: WF_EVENT.RAISE3(p_event_name => 'oracle.apps.igs.pe.genusr',

2136: OPEN c_seq_num;
2137: FETCH c_seq_num INTO ln_seq_val;
2138: CLOSE c_seq_num ;
2139:
2140: WF_EVENT.RAISE3(p_event_name => 'oracle.apps.igs.pe.genusr',
2141: p_event_key => 'GENERATE_USERNAME'||ln_seq_val,
2142: p_event_data => NULL,
2143: p_parameter_list => l_parameter_list_t,
2144: p_send_date => sysdate

Line 2147: p_user_name := UPPER(WF_EVENT.getValueForParameter ('USER_NAME',l_parameter_list_t));

2143: p_parameter_list => l_parameter_list_t,
2144: p_send_date => sysdate
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;