DBA Data[Home] [Help]

APPS.PVX_MISC_PVT dependencies on FND_FILE

Line 1877: FND_FILE.PUT_LINE( FND_FILE.LOG, fnd_message.get );

1873:
1874: FND_MESSAGE.SET_TOKEN( token => 'P_DATE_TIME'
1875: ,value => TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') );
1876:
1877: FND_FILE.PUT_LINE( FND_FILE.LOG, fnd_message.get );
1878: FND_FILE.NEW_LINE( FND_FILE.LOG, 1 );
1879:
1880:
1881: l_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 1878: FND_FILE.NEW_LINE( FND_FILE.LOG, 1 );

1874: FND_MESSAGE.SET_TOKEN( token => 'P_DATE_TIME'
1875: ,value => TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') );
1876:
1877: FND_FILE.PUT_LINE( FND_FILE.LOG, fnd_message.get );
1878: FND_FILE.NEW_LINE( FND_FILE.LOG, 1 );
1879:
1880:
1881: l_return_status := FND_API.G_RET_STS_SUCCESS ;
1882:

Line 1998: FND_FILE.PUT_LINE( FND_FILE.LOG, l_message );

1994: FND_MESSAGE.SET_TOKEN( token => 'PARTNER'
1995: ,value => l_partner_name || ' (' || l_partner_number || ')');
1996: l_message := FND_MESSAGE.get;
1997:
1998: FND_FILE.PUT_LINE( FND_FILE.LOG, l_message );
1999: FND_FILE.NEW_LINE( FND_FILE.LOG, 1 );
2000:
2001: IF l_msg_count > 0 THEN
2002: l_message := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first, p_encoded => FND_API.g_false);

Line 1999: FND_FILE.NEW_LINE( FND_FILE.LOG, 1 );

1995: ,value => l_partner_name || ' (' || l_partner_number || ')');
1996: l_message := FND_MESSAGE.get;
1997:
1998: FND_FILE.PUT_LINE( FND_FILE.LOG, l_message );
1999: FND_FILE.NEW_LINE( FND_FILE.LOG, 1 );
2000:
2001: IF l_msg_count > 0 THEN
2002: l_message := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first, p_encoded => FND_API.g_false);
2003: while (l_message is not null)

Line 2005: fnd_file.put_line(FND_FILE.LOG,substr(l_message,1,200));

2001: IF l_msg_count > 0 THEN
2002: l_message := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first, p_encoded => FND_API.g_false);
2003: while (l_message is not null)
2004: LOOP
2005: fnd_file.put_line(FND_FILE.LOG,substr(l_message,1,200));
2006: l_message := fnd_msg_pub.get(p_encoded => FND_API.g_false);
2007: END LOOP;
2008: END IF;
2009:

Line 2025: FND_FILE.PUT_LINE( FND_FILE.LOG, l_message );

2021: ,name => 'PV_PARTNER_STATUS_COMPLET_FAIL');
2022: FND_MSG_PUB.ADD;
2023: l_message := FND_MESSAGE.get;
2024:
2025: FND_FILE.PUT_LINE( FND_FILE.LOG, l_message );
2026: FND_FILE.NEW_LINE( FND_FILE.LOG, 1 );
2027:
2028: RETCODE := 2;
2029: ERRBUF := l_message;

Line 2026: FND_FILE.NEW_LINE( FND_FILE.LOG, 1 );

2022: FND_MSG_PUB.ADD;
2023: l_message := FND_MESSAGE.get;
2024:
2025: FND_FILE.PUT_LINE( FND_FILE.LOG, l_message );
2026: FND_FILE.NEW_LINE( FND_FILE.LOG, 1 );
2027:
2028: RETCODE := 2;
2029: ERRBUF := l_message;
2030:

Line 2041: FND_FILE.PUT_LINE( FND_FILE.LOG, l_message );

2037: FND_MESSAGE.SET_TOKEN( token => 'ERROR_PARTNERS'
2038: ,value => l_error_partners);
2039: l_message := FND_MESSAGE.get;
2040:
2041: FND_FILE.PUT_LINE( FND_FILE.LOG, l_message );
2042: FND_FILE.NEW_LINE( FND_FILE.LOG, 1 );
2043:
2044: RETCODE := 1;
2045: ERRBUF := l_message;

Line 2042: FND_FILE.NEW_LINE( FND_FILE.LOG, 1 );

2038: ,value => l_error_partners);
2039: l_message := FND_MESSAGE.get;
2040:
2041: FND_FILE.PUT_LINE( FND_FILE.LOG, l_message );
2042: FND_FILE.NEW_LINE( FND_FILE.LOG, 1 );
2043:
2044: RETCODE := 1;
2045: ERRBUF := l_message;
2046:

Line 2052: FND_FILE.PUT_LINE( FND_FILE.LOG, l_message );

2048: FND_MESSAGE.SET_NAME( application => 'PV'
2049: ,name => 'PV_PARTNER_STATUS_SUCCESS');
2050: l_message := FND_MESSAGE.get;
2051:
2052: FND_FILE.PUT_LINE( FND_FILE.LOG, l_message );
2053: FND_FILE.NEW_LINE( FND_FILE.LOG, 1 );
2054:
2055: RETCODE := 0;
2056: ERRBUF := l_message;

Line 2053: FND_FILE.NEW_LINE( FND_FILE.LOG, 1 );

2049: ,name => 'PV_PARTNER_STATUS_SUCCESS');
2050: l_message := FND_MESSAGE.get;
2051:
2052: FND_FILE.PUT_LINE( FND_FILE.LOG, l_message );
2053: FND_FILE.NEW_LINE( FND_FILE.LOG, 1 );
2054:
2055: RETCODE := 0;
2056: ERRBUF := l_message;
2057: END IF;

Line 2065: FND_FILE.PUT_LINE( FND_FILE.LOG, fnd_message.get );

2061:
2062: FND_MESSAGE.SET_TOKEN( token => 'P_DATE_TIME'
2063: ,value => TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') );
2064:
2065: FND_FILE.PUT_LINE( FND_FILE.LOG, fnd_message.get );
2066: FND_FILE.NEW_LINE( FND_FILE.LOG, 1 );
2067:
2068: EXCEPTION
2069: WHEN OTHERS THEN

Line 2066: FND_FILE.NEW_LINE( FND_FILE.LOG, 1 );

2062: FND_MESSAGE.SET_TOKEN( token => 'P_DATE_TIME'
2063: ,value => TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') );
2064:
2065: FND_FILE.PUT_LINE( FND_FILE.LOG, fnd_message.get );
2066: FND_FILE.NEW_LINE( FND_FILE.LOG, 1 );
2067:
2068: EXCEPTION
2069: WHEN OTHERS THEN
2070: ROLLBACK;

Line 2078: FND_FILE.PUT_LINE( FND_FILE.LOG, l_message );

2074: ,value => 'Database Error:'||sqlcode||' '||sqlerrm);
2075: FND_MSG_PUB.ADD;
2076: l_message := FND_MESSAGE.get;
2077:
2078: FND_FILE.PUT_LINE( FND_FILE.LOG, l_message );
2079: FND_FILE.NEW_LINE( FND_FILE.LOG, 1 );
2080:
2081: FND_MESSAGE.SET_NAME( application => 'PV'
2082: ,name => 'PV_UNKNOWN_ERROR');

Line 2079: FND_FILE.NEW_LINE( FND_FILE.LOG, 1 );

2075: FND_MSG_PUB.ADD;
2076: l_message := FND_MESSAGE.get;
2077:
2078: FND_FILE.PUT_LINE( FND_FILE.LOG, l_message );
2079: FND_FILE.NEW_LINE( FND_FILE.LOG, 1 );
2080:
2081: FND_MESSAGE.SET_NAME( application => 'PV'
2082: ,name => 'PV_UNKNOWN_ERROR');
2083: RETCODE := 1;

Line 2187: FND_FILE.PUT_LINE( FND_FILE.LOG, fnd_message.get );

2183: FND_MESSAGE.SET_TOKEN(
2184: token => 'P_DATE_TIME'
2185: ,value => TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') );
2186:
2187: FND_FILE.PUT_LINE( FND_FILE.LOG, fnd_message.get );
2188: FND_FILE.NEW_LINE( FND_FILE.LOG, 1 );
2189:
2190: /** Create a TCA account for partners if it does not exist **/
2191: account_rec.Created_by_Module := 'TCA_V2_API';

Line 2188: FND_FILE.NEW_LINE( FND_FILE.LOG, 1 );

2184: token => 'P_DATE_TIME'
2185: ,value => TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') );
2186:
2187: FND_FILE.PUT_LINE( FND_FILE.LOG, fnd_message.get );
2188: FND_FILE.NEW_LINE( FND_FILE.LOG, 1 );
2189:
2190: /** Create a TCA account for partners if it does not exist **/
2191: account_rec.Created_by_Module := 'TCA_V2_API';
2192: organization_rec.Created_by_Module := 'TCA_V2_API';

Line 2256: FND_FILE.PUT_LINE( FND_FILE.LOG, substr(l_partner_info,1,50)||substr(l_message,1,500) );

2252: l_message := l_message||fnd_msg_pub.get(p_encoded => FND_API.g_false);
2253: END LOOP;
2254: END IF;
2255:
2256: FND_FILE.PUT_LINE( FND_FILE.LOG, substr(l_partner_info,1,50)||substr(l_message,1,500) );
2257: FND_FILE.NEW_LINE( FND_FILE.LOG, 1 );
2258: RETCODE := '2';
2259:
2260: WHEN OTHERS THEN

Line 2257: FND_FILE.NEW_LINE( FND_FILE.LOG, 1 );

2253: END LOOP;
2254: END IF;
2255:
2256: FND_FILE.PUT_LINE( FND_FILE.LOG, substr(l_partner_info,1,50)||substr(l_message,1,500) );
2257: FND_FILE.NEW_LINE( FND_FILE.LOG, 1 );
2258: RETCODE := '2';
2259:
2260: WHEN OTHERS THEN
2261: ROLLBACK TO create_cust_account;

Line 2274: FND_FILE.PUT_LINE( FND_FILE.LOG, substr(l_partner_info,1,50)||substr(l_message,1,500) );

2270: l_message := l_message||fnd_msg_pub.get(p_encoded => FND_API.g_false);
2271: END LOOP;
2272: END IF;
2273:
2274: FND_FILE.PUT_LINE( FND_FILE.LOG, substr(l_partner_info,1,50)||substr(l_message,1,500) );
2275: FND_FILE.NEW_LINE( FND_FILE.LOG, 1 );
2276: RETCODE := '2';
2277: END ; /* END of the Internal BEGIN */
2278:

Line 2275: FND_FILE.NEW_LINE( FND_FILE.LOG, 1 );

2271: END LOOP;
2272: END IF;
2273:
2274: FND_FILE.PUT_LINE( FND_FILE.LOG, substr(l_partner_info,1,50)||substr(l_message,1,500) );
2275: FND_FILE.NEW_LINE( FND_FILE.LOG, 1 );
2276: RETCODE := '2';
2277: END ; /* END of the Internal BEGIN */
2278:
2279: END LOOP; /* k in 1 .. l_ptnr_party_id_array.count */

Line 2301: FND_FILE.PUT_LINE( FND_FILE.LOG, fnd_message.get );

2297: FND_MESSAGE.SET_TOKEN(
2298: token => 'P_DATE_TIME'
2299: ,value => TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') );
2300:
2301: FND_FILE.PUT_LINE( FND_FILE.LOG, fnd_message.get );
2302: FND_FILE.NEW_LINE( FND_FILE.LOG, 1 );
2303:
2304: /** Assign an account to contact **/
2305: open c_get_prtnrcntct_wo_role;

Line 2302: FND_FILE.NEW_LINE( FND_FILE.LOG, 1 );

2298: token => 'P_DATE_TIME'
2299: ,value => TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') );
2300:
2301: FND_FILE.PUT_LINE( FND_FILE.LOG, fnd_message.get );
2302: FND_FILE.NEW_LINE( FND_FILE.LOG, 1 );
2303:
2304: /** Assign an account to contact **/
2305: open c_get_prtnrcntct_wo_role;
2306: LOOP

Line 2334: FND_FILE.PUT_LINE( FND_FILE.LOG, substr(l_partner_info,1,60)||fnd_api.G_RET_STS_SUCCESS );

2330: IF (l_return_status <> fnd_api.G_RET_STS_SUCCESS) THEN
2331: RAISE FND_API.G_EXC_ERROR;
2332: END IF;
2333:
2334: FND_FILE.PUT_LINE( FND_FILE.LOG, substr(l_partner_info,1,60)||fnd_api.G_RET_STS_SUCCESS );
2335: COMMIT;
2336: EXCEPTION
2337:
2338: WHEN Fnd_Api.G_EXC_ERROR THEN

Line 2351: FND_FILE.PUT_LINE( FND_FILE.LOG, substr(l_partner_info,1,60)||substr(l_message,1,500) );

2347: l_message := l_message||fnd_msg_pub.get(p_encoded => FND_API.g_false);
2348: END LOOP;
2349: END IF;
2350:
2351: FND_FILE.PUT_LINE( FND_FILE.LOG, substr(l_partner_info,1,60)||substr(l_message,1,500) );
2352: FND_FILE.NEW_LINE( FND_FILE.LOG, 1 );
2353:
2354: WHEN OTHERS THEN
2355: ROLLBACK TO create_cust_account_role;

Line 2352: FND_FILE.NEW_LINE( FND_FILE.LOG, 1 );

2348: END LOOP;
2349: END IF;
2350:
2351: FND_FILE.PUT_LINE( FND_FILE.LOG, substr(l_partner_info,1,60)||substr(l_message,1,500) );
2352: FND_FILE.NEW_LINE( FND_FILE.LOG, 1 );
2353:
2354: WHEN OTHERS THEN
2355: ROLLBACK TO create_cust_account_role;
2356: l_message := null;

Line 2368: FND_FILE.PUT_LINE( FND_FILE.LOG, substr(l_partner_info,1,60)||substr(l_message,1,500) );

2364: l_message := l_message||fnd_msg_pub.get(p_encoded => FND_API.g_false);
2365: END LOOP;
2366: END IF;
2367:
2368: FND_FILE.PUT_LINE( FND_FILE.LOG, substr(l_partner_info,1,60)||substr(l_message,1,500) );
2369: FND_FILE.NEW_LINE( FND_FILE.LOG, 1 );
2370:
2371: END ; /* END of the Internal BEGIN */
2372: end loop;

Line 2369: FND_FILE.NEW_LINE( FND_FILE.LOG, 1 );

2365: END LOOP;
2366: END IF;
2367:
2368: FND_FILE.PUT_LINE( FND_FILE.LOG, substr(l_partner_info,1,60)||substr(l_message,1,500) );
2369: FND_FILE.NEW_LINE( FND_FILE.LOG, 1 );
2370:
2371: END ; /* END of the Internal BEGIN */
2372: end loop;
2373: exit when c_get_prtnrcntct_wo_role%notfound;